导入中文数据时提示ORA-01756: quoted string not properly terminated
SQL> insert into tab_a ('10000','YLN','','');
1 row created.
SQL> insert into tab_a ('10000','伊丽娜','','');
ERROR:
ORA-01756: quoted string not properly terminated
SQL> select userenv('language') from dual;
USERENV('LANGUAGE')
----------------------------------------------------
SIMPLIFIED CHINESE_CHINA.ZHS16GBK
将CRT的字符集设置为中文GBK,保持数据库与CRT的字符集一致即可。
转载于:https://blog.51cto.com/hunt1574/966213