February 15, 2008 at 1:05 pm
I have a table that has a description column using NVARCHAR so I can put in description in any language.
When I put in data in different language in that column, I only see ??? when I open the table. What kind of Collation I need to put in for that particular column so I can see different language?
February 15, 2008 at 1:24 pm
Loner (2/15/2008)
I have a table that has a description column using NVARCHAR so I can put in description in any language.When I put in data in different language in that column, I only see ??? when I open the table. What kind of Collation I need to put in for that particular column so I can see different language?
When you "see" ??? that is CLIENT side unicode settings. If you use let's say a chinese unicode character it is responsibility of the "client" to render it correctly. Be careful though in case the application that "inserted" that character was not unicode "aware" because then it was that app who did the translation from unicode to "???"
HTH
* Noel
February 15, 2008 at 1:43 pm
Try going to control panel -> regional and language options -> languages tab and checking the options in supplemental language support (you might need the OS disks).
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply