SQL*Plus: Release 10.2.0.1.0 - Production on Wed Sep 23 10:57:21 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP and Data Mining Scoring Engine options
sec@ora10g> drop table t purge;
Table dropped.
sec@ora10g> create table t (x varchar2(10 char));
Table created.
sec@ora10g> insert into t values ('侯');
ERROR:
ORA-01756: quoted string not properly terminated
这只是一个影响,另外一个著名的影响就是加中文comments的时候也报这样的错误
sec@ora10g> comment on table t is '侯';
ERROR:
ORA-01756: quoted string not properly terminated
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Sep 23 11:05:07 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP and Data Mining Scoring Engine options
sec@ora10g> insert into t values ('侯');
1 row created.
sec@ora10g> comment on table t is '侯';
Comment created.
sec@ora10g> col DUMP(X) for a30
sec@ora10g> select x,dump(x) from t;
X DUMP(X)
-------------------- ------------------------------
侯 Typ=1 Len=3: 228,190,175