Search code examples
c#sql-server-2005sql-server-2005-express

How to store Vietnamese characters in SQL Server 2005?

I wanted to add my colleague's information in my database for testing purposes. Since he his from Vietnam, his name has a special Vietnamese character in it ('ơ'). When I updated the database, the character was transformed to a regular 'o'...

How can I store that kind of special character inside SQL Server Express 2005?

Solution

  • nvarchar and nchar

    SUMMARY: Character data types that are either fixed-length, nchar, or variable-length, nvarchar, Unicode data and use the UNICODE UCS-2 character set.