Oracle occupies several bytes of a Chinese character

A Chinese Character occupies several bytes in Oracle, which is determined by the character set encoding in Oracle.

View character sets on oracle server

Select userenv ('language') from dual;

If the following figure is displayed, a Chinese character occupies two bytes.

SIMPLIFIED CHINESE_CHINA.ZHS16GBK

If the following figure is displayed, a Chinese character occupies three bytes.

SIMPLIFIED CHINESE_CHINA.AL32UTF8

You can use the following statement to query the length of a Chinese character in bytes.

Select lengthb ('you') from dual;