Insert Chinese characters in database

[sdhawan]

Hi ,
I am trying to insert chinese characters in database using sql statement but they appear as '????????' in the databse.Can anyone help me with this .

Thanks

[tweety1313]

Try to change the column datatype that contain the chineese characters from char() to nchar() or from varchar() to nvarchar().

[Ketsuekiame]

Also, make sure that the database itself is configured to allow them (Often labelled as Unicode)

[sdhawan]

Hi Thanks for teh reply .I am using nvarchar but how can i configure for unicode.Thanks again

[Ketsuekiame]

Ah, as you're using MS SQL, using the nvarchar will store as unicode so you shouldn't be having the issue. Does it decode correctly when you pull back the data? It could just be that your viewing font doesn't support unicode.

[sdhawan]

right now i have just inserted them in database .I ll try to see what they look like when i ll pull them back .thanks