Question about asp with stored procedure

I not sure I posted in right newsgroup or wrong
but i need your help, thanks~
I am using ASP to write a web application, and which will called a sql 2000
stored procedure through ADODB.Recordset
I can store all provided information correctly if I am type English, other
language such as Tradition chinese or Simplify chinese cannot stored
correctly
And I have saved the asp page as utf-8, and codepage=65001 and
content-type=utf-8
I not sure the problem is that i cannot provide utf-8 data to stored
procedure or not.
Any suggestion?
ThanksHi
As the parameters for the SP NCHAR/NVARCHAR?
You need to use UNICODE data types for most Eastern Languages.
--
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"oa¤?@.¤?￥q" wrote:

> I not sure I posted in right newsgroup or wrong
> but i need your help, thanks~
> I am using ASP to write a web application, and which will called a sql 200
0
> stored procedure through ADODB.Recordset
> I can store all provided information correctly if I am type English, other
> language such as Tradition chinese or Simplify chinese cannot stored
> correctly
> And I have saved the asp page as utf-8, and codepage=65001 and
> content-type=utf-8
> I not sure the problem is that i cannot provide utf-8 data to stored
> procedure or not.
> Any suggestion?
> Thanks
>
>|||Yes
In the stored procedure, I used nvarchar to get the value, which passed from
ASP program
However, the data got by stored procedure is not correct
Do you know why'
Or any I need to do to correct my program?
Thanks~
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:C9401DAF-90AF-40DD-ABF6-5673555ABACD@.microsoft.com...
> Hi
> As the parameters for the SP NCHAR/NVARCHAR?
> You need to use UNICODE data types for most Eastern Languages.
> --
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
>
> "oa?O@.'Dq" wrote:
>
2000
other