different character sets on same server

[Mnemonical]

you can have database character set and national character set, exactly US7ASCII and UTF8 as you wanted. When you want to use US7ASCII, just use CHAR, else if you wnat UTF, use NCHAR.


F.