Dear all,

I want to know how to store and handle Chinese (double byte character) in SQL 7 database with
English Windows NT Server operating system?

I have tried to store some chinese character in table column defined as "char" or "nchar".
These work. I can select, insert and delete.

But the problem is when I use some function such as upper or lower, some single byte
character will be converted and when combining the other single byte character, the
double byte character is changed. How to avoid these problem?

Is this related to the code page setting?

Character set: 1252/ISO charset
Sort order: dictionary order, case-sensitive
Locale identifier: general unicode


Kenny