时间: 2021-08-13 作者:daque
往日在做一个体例时,遇到了一个题目!即日偶尔之中找到了这个题目的处置本领,贴出来!!!
题目刻画:
varchar2(4000) abc;
intert into table_name(abc) values('这边有1500个中国字……');
报错:插入字符过长!过程尝试,创造一个中国字占3个字节,以是报错!!!
题目地方:
运用的字符集是utf8,就有大概展示这个缺点!
运用吩咐察看:
sql> select * from v$nls_parameters where parameter='nls_characterset';
parameter
--------------------------------------------------------------------------------
value
--------------------------------------------------------------------------------
nls_characterset
al32utf8
处置本领:
倡导运用zhs16gbk字符集!
操纵:
sql> shutdown immediate;
sql> startup mount;
sql> alter system enable restricted session;
sql> alter system set job_queue_processes=0;
sql> alter database open;
sql> alter database character set al32utf8/zhs16gbk;
sql> shutdown immediate;
sql> startup;
题目处置!