SQL Server 2008 r2: vietnamese letters are not stored correctly

Question

The problem is the following: I have a column of type nvarchar, collation is set to Vietnamese_CI_AS. I insert some data containing vietnamese letters (using MS SQL Server Management studio). And then it is not displayed correctly in SQL Server Management studio and application.

Data:

Result

Any suggestions?

what is the data type of the Name column? - it has to be nvarchar or have the correct collation — Gavin, Oct 19 '14 at 19:42
also if you are writing sql you need to use N INSERT INTO MYTABLE (NAME) VALUES (N'my vietnamese') N signifies unicode to sql server — Gavin, Oct 19 '14 at 19:45

score 1 · Accepted Answer · edited May 23 '17 at 11:56

1

You must always declare N before inserting any values. N stands for national language character set.

Have a look at this post to get a better understanding.

What is the difference between varchar and nvarchar?

edited May 23 '17 at 11:56

Community

1
1

answered Oct 19 '14 at 23:32

sqluser

5,502
7
36
50

SQL Server 2008 r2: vietnamese letters are not stored correctly

1 Answers1