Chinese and Japanese characters in database

Question

I have Customer table in which Name column can contain Chinese characters. I have given it's datatype as NVARCHAR. I am writing simple SELECT statement. But it is showing question marks instead of Chinese characters. What should I do to get correct data? In Below Image, you can see that after 2nd statement, @NAME variable value automatically gets those question marks which is not returning correct answer.

Answer 1

Hello,

You have to add the Unicode literal N in front of the string, like

SET @NAME = N'here comes the text';

---

Olaf Helper

[ Blog] [ Xing] [ MVP]

Answer 2

Thank you Olaf :)

It worked for me.