I have encountered a problem when I did a system! I found out this problem in it. I posted it !!! Question Description: varchar2 (4000) ABC; Intert Into Table_name (ABC) VALUES ('There are 1500 here) Chinese characters ... '); error: Insert characters are too long! After testing, I found a Chinese character accounted for 3 bytes, so I'm wrong! ! ! The problem is where the character set is used is UTF8, which may have this error! Use the command to view: SQL> SELECT * FROM V $ NLS_PARAMETERS WHERE parameter = 'nls_characterset'; parameter ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ -------------------------------------------------- Value -------------------------------------------------- ------------------------------- NLS_CharacterSet Al32UTF8 Solution: It is recommended to use the zhs16GBK character set! Operation: 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; problem solving! ! !
Author Blog:
http://blog.9cbs.net/ufoer23/
