怎样才能在ORACLE里显示或输入中文？

canddy

HELLO,A wu

我刚刚装了oracle8.1.6英文版。在oracle8.1.6 for win2000 server 里，安装时可以手动选择字符集。所以我的简体，繁体,都可以看到在database里。


canddyliu 2001.12.01

flytiger

我觉得关键在于客户端跟服务器端的字符集必须一致
无论插入什么形式的字符，都能看到
一旦两者的字符集不一致了，输入的只有？？？

leo.liu

谢谢各位的帮忙，终于可以显示中文了，我最后用的字符集代码是：
   SIMPLIFIED CHINESE_CHINA.ZHS16GBK

jiang

Firstly, You must use CHINESE character set or a character set which including CHINESE when you create your database;

Secondly, environment variable NLS_LANG of your client must set to the character set which contain CHINESE character set, and the character set must be a sub-set of the DB server character set , and as the same time, the OS of your Client must can DISPLAY data whose encoding is NLS_LANG.