How do I insert Chinese characters into a SQLExpress text field?
Solution 1
Just add an 'N' before your text delimiter in the INSERT/UPDATE statement for fields of the nchar/nvarchar/ntext type:
INSERT INTO myTable (myField1, myField2) VALUES (N'any chinese character',N'any arabic character')
Solution 2
Be sure you made your column type nchar, nvarchar or ntext. So you can store Unicode. It is all rather well described here...
Related videos on Youtube
03 : 35
09 : 35
02 : 21
17 : 02
01 : 50
02 : 14
07 : 00
03 : 05
01 : 28
Makoto
Stack Overflow Inc. is treating the community which built it up as a dispensable tool in its quest to maintain relevance and market share. While I have no qualms with the network needing to make money, delivering a "product" and then asking the community to "add value" to it is not the path forward that I seek. In light of leadership's hard-line stance to this, the only form of civil disobedience we have at our disposal is to simply cease all moderation, which is the only real value-add we normal users of the site have brought.
Updated on May 04, 2020Comments
-
Makoto almost 4 years
How do I insert Chinese characters into a SQLExpress text field? I'm using SQL Express from VS 2008. When I add Chinese characters, either via an import app I wrote or by pasting them in from the data view inside Visual Studio, they end up as question marks.