NVARCHAR2的问题。
1:问题如下
Connected to Oracle8 Release 8.0.5.0.0
Connected as system
SQL> desc message_content;
Name Type Nullable Default Comments
--------------- --------------- -------- ------- --------
MESSAGE_ID NUMBER
MESSAGE_CONTENT NVARCHAR2(4000) Y
SQL> insert into message_content values(1,'zhaolh');
insert into message_content values(1,'zhaolh')
ORA-12704: 字符集不匹配
2;我查了一下配置如下;
SQL> select name,value$ from sys.props$;
NAME VALUE$
------------------------------ --------------------------------------------------------------------------------
DICT.BASE 2
NLS_LANGUAGE SIMPLIFIED CHINESE
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-YY
NLS_DATE_LANGUAGE AMERICAN
NLS_CHARACTERSET ZHS16GBK
NLS_SORT BINARY
NLS_NCHAR_CHARACTERSET ZHS16GBK
NLS_RDBMS_VERSION 8.0.5.0.0
GLOBAL_DB_NAME CCDB.WORLD
EXPORT_VIEWS_VERSION 7
15 rows selected