1, today to investigate an Oracle database problem, found in 11g a Chinese character accounted for 2 bytes, in 10g accounted for 3 bytes, resulting in 11g database data import into 10g always error, at the beginning of the thought is 11g and 10g version is not the same, Chinese characters occupy a different number of bytes, and then I think, Oracle will not do so, so the difference is too big, and then a survey, found to be related to the Oracle Character set encoding:
If it is the following character set, a Chinese character occupies 2 bytes: simplified Chinese_china. ZHS16GBK If the character set is the following, a Chinese character occupies 3 bytes: simplified Chinese_china. Al32utf8 (1) View the Oracle character set can be viewed in the following SQL text: Select Userenv (' language ') from dual (2) See how many bytes a Chinese character occupies in the current Oracle environment can be viewed in the following SQL text: Select LENGTHB (' Ah ') from dual knowledge about Oracle Character set (including character set viewing and modification), main references: HTTP://WWW.CNBLOGS.COM/ROOTQ/ARTICLES/2 049324.html http://blog.csdn.net/uestcong/article/details/7348008
Oracle Kanji occupies byte length