0

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?

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Julien Poulin
  • 12,737
  • 10
  • 51
  • 76

4 Answers4

2

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
  • 19,509
  • 9
  • 45
  • 63
2

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.

KV Prajapati
  • 93,659
  • 19
  • 148
  • 186
1

You may need to use the NVARCHAR Data Type?

Mark Redman
  • 24,079
  • 20
  • 92
  • 147
0

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

Carles Company
  • 7,118
  • 5
  • 49
  • 75