Thursday, March 8, 2012

Chinese characters in SQL 2000

Hi All
I have to develop a website which allows users to enter their comments into Chinese languages. I need sql2000 to support the chinese characters.
I am experienced .net web programmer, but have very little knowledge on the database side. Would really appreciate any help on this
THanks
JigneshI have already declared the column as nvarchar.
I installed windows XP language bar on my machine. So when I go to enterprise manager, I can type in chinese characters in the database directly and then can view them on my ASP.net page.
But when I try to insert a record from an ASP.net page by typing chinese characters in the text box, they are all converted to ?.

Quote:

Originally posted by patel_o
Hi All
I have to develop a website which allows users to enter their comments into Chinese languages. I need sql2000 to support the chinese characters.
I am experienced .net web programmer, but have very little knowledge on the database side. Would really appreciate any help on this
THanks
Jignesh

No comments:

Post a Comment