How to insert chinese characters into SQLExpress textbox?
How to insert Chinese characters into SQLExpress textbox? I have been using SQL Express since VS 2008. When I add Chinese characters, either through an imported application I wrote or inserting from a data view inside Visual Studio, they end up as question marks.
+5
Martin Shoemaker
source
to share
2 answers
Just add 'N' before the text delimiter in INSERT / UPDATE statements for nchar / nvarchar / ntext fields:
INSERT INTO myTable (myField1, myField2) VALUES (N'any chinese character, N'any arabic character)
+8
Philippe grondier
source
to share
Make sure you create your nchar, nvarchar or ntext column type. This way you can keep Unicode. It's all pretty well described here ...
+4
Hans Passant
source
to share