Oracle character encoding and the processing of Chinese character storage length

Execute the following statement to see the bytes that the Chinese character occupies in the database:

Select Vsize (' Han ') from dual;

In general, the resulting results are mostly values: 2 or 3

The Oracle database is installed under General Linux, the default character encoding is set to: Al32utf8, each kanji account is 3 bytes

Under Windows platform, the default character encoding is set to: ZHS16GBK, each kanji account is 2 bytes

See the SQL for the Oracle service-side character encoding as follows:

Select Userenv (' language ') from dual;

Data migration and front-end character length check, especially attention to character encoding problem!

Oracle character encoding and the processing of Chinese character storage length