CODEWITHSUNDEEP
sql-serverunicode
berliner
berliner

Reputation: 1955

SQL Server 2008 r2: vietnamese letters are not stored correctly

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:

Data

Result

Result

Any suggestions?

Upvotes: 2

Views: 2751

Answers (1)

sqluser
sqluser

Reputation: 5672

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?

Upvotes: 1

Related Questions