[RESOLVED] How to use/set Multilanguage in the SQL Server 2005?

Hi guys,

how to insert a chinese character in the table?

I insert it but it shows ?????

please advice. Thanks in advance.

Are you inserting the data into a field with a data type that starts with N (such as NVarChar)? If not, you need to do that.

Next up, when you insert data, are you using an SQL statement to do that? If so, you need to put N before the quotes (eg: myfield = N'value')


If that is all OK, how are you looking at the data? Many programs (including database management tools) don't display unicode data, so will show ?? instead of the actual data - but the data will still be there (you just need to view it somewhere that supports unicode).

it work now

Thanks for the info!

Sorry for the delay replied. Hail si_the_geek! :)