CODEWITHSUNDEEP
sql-serverssms
Svetoslav Panteleev
Svetoslav Panteleev

Reputation: 119

Cyrillic alphabet doesnt work with Microsoft SQL Server Management Studio

I am using SQL Server database, and I need to store some texts written using Cyrillic alphabet.

I use Microsoft SQL Server Management Studio to enter, view and manipulate data.

But when I insert data like

INSERT INTO USP14_Table (Tip_DB, Suma_DB, Opisanie_DB,Kategoria_DB, Data_DB, Mesec_DB) 
VALUES ('саса', 21, 'саса', 'саса', 'саса',2);

The result is:

[Picture of problem1

I search the problem, but I only find the following solution. I had to change the column type from varchar to nvarchar, but this doesn't work.

Upvotes: 0

Views: 1305

Answers (2)

Denys
Denys

Reputation: 11

in this case - collation is the worst decision. just use N symbol before string for exmpl: select N'Коментатор выше нуб'

Upvotes: 1

Hassan Hosseini
Hassan Hosseini

Reputation: 420

Problem is that your database collation does not support the letters.

Right-click the database that you want and click Properties.

Click the Options page, and select a right collation from the Collation drop-down list.

Upvotes: 1

Related Questions