Is your SQL statement passing the value in to the db as a unicode value?
e.g. basic example
INSERT YourTable VALUES ('Unicode Value')
INSERT YourTable VALUES (N'Unicode Value')
Obviously I'd recommend you use parameterised SQL/stored procedure
and define the parameter as an NVARCHAR, but you get what I'm saying.
Work out what's going on by taking each piece of the pipeline separately.
See my article on http://pobox.com/%7Eskeet/csharp/debuggingunicode.html and diagnose where things are going wrong. Places that you may be seeing problems:
- Getting the data from the user
- Updating the database
- Fetching from the database
- Displaying the data you've fetched
Check each of these independently, never relying on any particular font etc. Print out the Unicode code points involved (as per the article).
Oh, and wherever you get to specify it, use an encoding which can encode everything - I'd suggest UTF-8.
Windows Forms apps
When entering text into a windows forms textbox you need to use a unicode font such as Arial Unicode MS.
Make sure you are using UTF-8 as your response codepage. Great article from Microsoft on exactly this http://support.microsoft.com/kb/893663
UTF-8 will correctly encode any characters. Keep in mind, NText and
NVarChar in your DB are UTF-16 datatypes, so viewing the data from Query
Analyser might will show it correctly.
In your SQL
If you're constructing the SQL dynamically, make sure you use the N prefix e.g.
INSERT INTO TABLE (Name, Number) VALUES (N'MyName', 1)