Interesting question~

[ºa¤Ö]

I find a interesting question, and I cannot solve it
@.@

If i want to insert unicode data, I need using recordset.addne w instead of
using "insert into table" query or "stored procedure"

All unicode data inserted into database through insert query or stored
procedure would become a question mark "?" no matter:
1. the field is nvarchar
2. the collpase is SQL_Latin_Gener al_CP1_XX_XX" or
"SQL_Latin_Gene ral_CP850_XX_XX "
3. the @codepage=65001
4. the charset of html page set to utf-8
5. or both above solution

That means i cannot hide my database structure by using stored procedure, i
need place ALL code inside asp and the asp become very heavy....

Any solution?

Thanks

[Aaron Bertrand [SQL Server MVP]]

This is not true. Did you prefix the string with the N character?

CREATE PROCEDURE dbo.foo
@param NVARCHAR(255)
AS
BEGIN
SET NOCOUNT ON
INSERT table(column) SELECT @param
END
GO

Then from ASP:

conn.execute "EXEC dbo.foo @param = N'bar'",,129

This works for me just fine.

"ºa¤Ö@¤½¥q" <ºa¤Ö@¾ã»æ.¨p¤H ¤½¥q> wrote in message
news:%2******** ********@tk2msf tngp13.phx.gbl. ..

I find a interesting question, and I cannot solve it
@.@

If i want to insert unicode data, I need using recordset.addne w instead of
using "insert into table" query or "stored procedure"

All unicode data inserted into database through insert query or stored
procedure would become a question mark "?" no matter:
1. the field is nvarchar
2. the collpase is SQL_Latin_Gener al_CP1_XX_XX" or
"SQL_Latin_Gene ral_CP850_XX_XX "
3. the @codepage=65001
4. the charset of html page set to utf-8
5. or both above solution

That means i cannot hide my database structure by using stored procedure,
i
need place ALL code inside asp and the asp become very heavy....

Any solution?

Thanks

[Dave Anderson]

ºa¤Ö@¤½¥q wrote:

If i want to insert unicode data, I need using
recordset.addne w instead of using "insert into
table" query or "stored procedure"

Not if you use an ADODB.Command object:
http://msdn.microsoft.com/library/en...objcommand.asp

Extending Aaron's example (but with server-side JScript):

var CMD = Server.CreateOb ject("ADODB.Com mand")

CMD.ActiveConne ction = { your open connection object }
CMD.CommandType = adCmdStoredProc
CMD.CommandText = "foo"

CMD.Parameters. Append(
CMD.CreateParam eter(
"@Param",adVarW Char,adParamInp ut,255,YourValu e
)
)
CMD.Execute()
CommandTypeEnum :
http://msdn.microsoft.com/library/en...ndtypeenum.asp
DataTypeEnum:
http://msdn.microsoft.com/library/en...tatypeenum.asp
ParameterDirect ionEnum:
http://msdn.microsoft.com/library/en...ectionenum.asp

--
Dave Anderson

Unsolicited commercial email will be read at a cost of $500 per message. Use
of this email address implies consent to these terms. Please do not contact
me directly or ask me to contact you directly for assistance. If your
question is worth asking, it's worth posting.

[Mark Schupp]

What DBMS?

--
--Mark Schupp
"ºa¤Ö@¤½¥q" <ºa¤Ö@¾ã»æ.¨p¤H ¤½¥q> wrote in message
news:%2******** ********@tk2msf tngp13.phx.gbl. ..

I find a interesting question, and I cannot solve it
@.@

If i want to insert unicode data, I need using recordset.addne w instead of
using "insert into table" query or "stored procedure"

All unicode data inserted into database through insert query or stored
procedure would become a question mark "?" no matter:
1. the field is nvarchar
2. the collpase is SQL_Latin_Gener al_CP1_XX_XX" or
"SQL_Latin_Gene ral_CP850_XX_XX "
3. the @codepage=65001
4. the charset of html page set to utf-8
5. or both above solution

That means i cannot hide my database structure by using stored procedure,
i
need place ALL code inside asp and the asp become very heavy....

Any solution?

Thanks

[ºa¤Ö]

yes~
I missed to mention it
I tried this way already

but still become question mark "?"
^.^

"Aaron Bertrand [SQL Server MVP]" <te*****@dnartr eb.noraa> wrote in message
news:ew******** ******@tk2msftn gp13.phx.gbl...

This is not true. Did you prefix the string with the N character?

CREATE PROCEDURE dbo.foo
@param NVARCHAR(255)
AS
BEGIN
SET NOCOUNT ON
INSERT table(column) SELECT @param
END
GO

Then from ASP:

conn.execute "EXEC dbo.foo @param = N'bar'",,129

This works for me just fine.

"ºa¤Ö@¤½¥q" <ºa¤Ö@¾ã»æ.¨p¤H ¤½¥q> wrote in message
news:%2******** ********@tk2msf tngp13.phx.gbl. ..

I find a interesting question, and I cannot solve it
@.@

If i want to insert unicode data, I need using recordset.addne w instead of using "insert into table" query or "stored procedure"

All unicode data inserted into database through insert query or stored
procedure would become a question mark "?" no matter:
1. the field is nvarchar
2. the collpase is SQL_Latin_Gener al_CP1_XX_XX" or
"SQL_Latin_Gene ral_CP850_XX_XX "
3. the @codepage=65001
4. the charset of html page set to utf-8
5. or both above solution

That means i cannot hide my database structure by using stored procedure, i
need place ALL code inside asp and the asp become very heavy....

Any solution?

Thanks

[ºa¤Ö]

I am using MS SQL2000 standard edition
^.^

"Mark Schupp" <no******@email .net> wrote in message
news:Os******** ******@TK2MSFTN GP12.phx.gbl...

What DBMS?

--
--Mark Schupp
"ºa¤Ö@¤½¥q" <ºa¤Ö@¾ã»æ.¨p¤H ¤½¥q> wrote in message
news:%2******** ********@tk2msf tngp13.phx.gbl. ..

I find a interesting question, and I cannot solve it
@.@

If i want to insert unicode data, I need using recordset.addne w instead of using "insert into table" query or "stored procedure"

All unicode data inserted into database through insert query or stored
procedure would become a question mark "?" no matter:
1. the field is nvarchar
2. the collpase is SQL_Latin_Gener al_CP1_XX_XX" or
"SQL_Latin_Gene ral_CP850_XX_XX "
3. the @codepage=65001
4. the charset of html page set to utf-8
5. or both above solution

That means i cannot hide my database structure by using stored procedure, i
need place ALL code inside asp and the asp become very heavy....

Any solution?

Thanks

[ºa¤Ö]

This one I tried with error occurred
Example:
table: customer
field: name_tc nvarchar(10)

and I used command object to create parameter object and append to
adodb.command
and the type should be
set param = createParameter ("@NameTc", adVarWChar, adInputParam, 10,
variable_of_nam e)

but dont know why the server prompt something like the length of data I
provided is longer than the field's length....

Let me try again
^.^

"Dave Anderson" <GT**********@s pammotel.com> wrote in message
news:11******** *****@corp.supe rnews.com...

ºa¤Ö@¤½¥q wrote:

If i want to insert unicode data, I need using
recordset.addne w instead of using "insert into
table" query or "stored procedure"
Not if you use an ADODB.Command object:
http://msdn.microsoft.com/library/en...objcommand.asp

Extending Aaron's example (but with server-side JScript):

var CMD = Server.CreateOb ject("ADODB.Com mand")

CMD.ActiveConne ction = { your open connection object }
CMD.CommandType = adCmdStoredProc
CMD.CommandText = "foo"

CMD.Parameters. Append(
CMD.CreateParam eter(
"@Param",adVarW Char,adParamInp ut,255,YourValu e
)
)
CMD.Execute()
CommandTypeEnum :

http://msdn.microsoft.com/library/en...ndtypeenum.asp DataTypeEnum:
http://msdn.microsoft.com/library/en...tatypeenum.asp
ParameterDirect ionEnum:
http://msdn.microsoft.com/library/en...ectionenum.asp
--
Dave Anderson

Unsolicited commercial email will be read at a cost of $500 per message. Use of this email address implies consent to these terms. Please do not contact me directly or ask me to contact you directly for assistance. If your
question is worth asking, it's worth posting.

[Aaron Bertrand [SQL Server MVP]]

> but still become question mark "?"

How have you verified that this is what is STORED? It sounds like this is
what you see when you display it on your web page, but I am not convinced
that what is in the database is ?

[ºa¤Ö]

Yes
I using MSSQL 2000 Enterprise Manager and query the database data
and it stored question mark as well
^.^

"Aaron Bertrand [SQL Server MVP]" <te*****@dnartr eb.noraa> wrote in message
news:%2******** ********@TK2MSF TNGP09.phx.gbl. ..

but still become question mark "?"

How have you verified that this is what is STORED? It sounds like this is
what you see when you display it on your web page, but I am not convinced
that what is in the database is ?