Oracle A Chinese character occupies several bytes, determined by the character set encoding in Oracle

Oracle A Chinese character occupies several bytes, depending on the character set encoding in Oracle

View the Oracle server-side character set

Select Userenv (' language ') from dual;

If shown below, a Chinese character occupies two bytes

Simplified Chinese_china. Zhs16gbk

If shown below, a Chinese character occupies three bytes

Simplified Chinese_china. Al32utf8

You can use the following statement to query the byte length occupied by a Chinese character

Select LENGTHB (' You ') from dual;

Oracle A Chinese character occupies several bytes, determined by the character set encoding in Oracle