Insert Russian Language data into database from an array

Question

My query looks like:

string str = string.Format("Insert into [MyDB].[dbo].[tlb1] ([file_path],[CONTENT1],[CONTENT2]) values ('{0}','{1}','{2}');", fullpath, _val[0], _val[1]);

Now when I insert data into database if array _val[] contains data in english language it insert correctly but when array contains data in Russian Language in database this show like ??????????????????????? Is there a way to insert data in Russian Language from an array.

Wich database you use? What codepage choised for this fields? — gabba
– gabba, Commented May 15, 2012 at 10:52
DataBase version: Microsoft SQL Server 2005 and fields are of nvarchar(max) — Manish
– Manish, Commented May 15, 2012 at 10:54

KyleMit · Accepted Answer · 2018-08-14 21:48:01Z

2

According to this (Archived) Microsoft Support Issue:

You must precede all Unicode strings with a prefix N when you deal with Unicode string constants in SQL Server

edited Aug 14, 2018 at 21:48

KyleMit♦

31.4k74 gold badges517 silver badges712 bronze badges

answered May 15, 2012 at 11:11

6opuc

1,1963 gold badges13 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Joey · Accepted Answer · 2012-05-15 11:11:45Z

1

First of all, you should use prepared statements and let the database driver insert the placeholders correctly (i.e. SqlCommand with parameters). Then the issue should go away (as well as any potential SQL injection problems).

As a quick fix in your case: Prefix the string literals you're inserting with N:

... values (N'{0}',N'{1}',N'{2}')

This causes the literals to be Unicode literals, not arbitrary-legacy-codepage ones and thus preventing the conversion from Unicode to the legacy codepage (which results in question marks for characters that cannot be represented).

answered May 15, 2012 at 11:11

Joey

357k88 gold badges705 silver badges700 bronze badges

Comments

RePierre · Accepted Answer · 2012-05-15 10:57:02Z

0

It seems that the datatype of columns [Content1] and [Content2] is nchar. You should convert the columns to nvarchar which is used to store unicode data.

answered May 15, 2012 at 10:57

RePierre

9,5762 gold badges24 silver badges38 bronze badges

2 Comments

Manish Over a year ago

datatype of columns is nvarchar not nchar

RePierre Over a year ago

Then try checking the collation of your server/database. More info here msdn.microsoft.com/en-us/library/ms143726(v=sql.90).aspx

Oleg · Accepted Answer · 2012-05-15 10:59:18Z

0

First of all you must see Database codepage at server. May be non-Unicode CP in database, but data from your app comes in Unicode format.

answered May 15, 2012 at 10:59

Oleg

1

Collectives™ on Stack Overflow

Insert Russian Language data into database from an array

4 Answers 4

Comments

Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related