views:

150

answers:

4

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?

+1  A: 

You may need to use the NVARCHAR Data Type?

Mark Redman
+2  A: 

At the very least, you'll need to use the nchar or nvarchar data type, and a client that supports unicode (such as Java or any .NET language).

Then, I'd expect it to just work..;-)

Tor Haugen
A: 

I suppose the best way is to make SQL server store the information using Unicode.

Carles
+2  A: 

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.

adatapost