0

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

3
Contributors
5
Replies
7
Views
7 Years
Discussion Span
Last Post by sdhawan
0

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

0

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

0

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.

Edited by Ketsuekiame: n/a

0

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

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.