Clever Geek Handbook

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


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


source


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


source






More articles:


All Articles