the Byte length of Chinese Character in Oracle.

Technology:      

                

SELECT VSIZE ('男') FROM DUAL ;

SELECT DUMP('男', 1016) FROM DUAL;

SELECT * FROM props$;

Problem:

               When we have a program to get data from other database. Because the columns in the other database is always changing.  So we use SUBSTR(string , position, substring_length)  to fix the length so that our application is not affected when the other database changed.But when Oracle's CharacterSet=UTF8  one Chinese Character is three byte.

Solution:

               If you define a column as Varchar2(200), you should use 200/3 = 66.7 as the substring_length, like substr(string,1,65).