how do u store double byte character in MSSQL
Posted on 2001-09-10
I'm using MSSQL 2000.
I'm trying to store double byte characters in it.
I created a table with only one field and use varchar (256).
However, it is not able to store the character as it is.
The character is converted into a question mark and store inside.
In the past, when I'm using Informix, I use something
call BLOB. And that works.
Is there an equivalent in MSSQL? Also, BLOB will be
a bit overkill as I'm storing labels like "CD Name",
Thanks in advanced.