Cyrillic alphabet with Microsoft SQL Server Management Studio

Question

I am using a SQL Server database and I need to save some texts written using the Cyrillic alphabet.

I use Microsoft SQL Server Management Studio to enter, view and manage data. But when I insert data like

Insert into EBook (TitleID, Title, ContentFile) values (N'', N' ', N'-  '); 

and then do SELECT, I see only ???? instead of texts.

I don’t even know if the data was saved incorrectly, or if Studio cannot display it correctly. How can this be fixed?

Answer 1

What is a data type - these columns?

For storage, for example, Cyrillic characters, they must be nvarchar(x)

I see the same phenomenon: with varchar(100) data goes in order, but appears like nothing more than question marks ??????? - but with nvarchar(100) everything is fine.