Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
patel_o
Starting Member
3 Posts |
 Posted - 2004-11-22 : 15:47:34
|
| 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 |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2004-11-23 : 04:46:54
|
| You need to look into using UNICODE columns....ie nvarchar, ntext, nchar....there are some restrictions with using them.You may also need to look into COLLATIONS....for ordering the data properly in SORTs.Search here on Chinese, Russian, Arabic....others with multilingual issues have gone down this path before. |
 |
|
|
patel_o
Starting Member
3 Posts |
Posted - 2004-11-23 : 09:46:14
|
| I am already using nvarchar as data type. 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 ??????. |
|
|
|
patel_o
Starting Member
3 Posts |
Posted - 2004-11-23 : 11:46:19
|
| I was doing some more trials and found out that only time when I can enter proper data in SQL is when I go to enterprise manager and type in the data in the cell myself ( just like Excel).But when I run the following query Insert into TestTable(Comments, Language) values('�²','chinese') even on the enterprise manager or query analyzer, the chinese characters are converted to ??????? |
|
|
|
|
|
|
Chinese Characters in SQL 2000