Member Avatar for 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

  • 3 Contributors
  • 5 Replies
  • 112 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by sdhawan
Member Avatar for tweety1313

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

Member Avatar for Ketsuekiame

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

Member Avatar for sdhawan

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

Member Avatar for 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.

Edited by Ketsuekiame because: n/a
Member Avatar for 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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.