SQL Language (MOSC)

MOSC Banner

LENGTH('Chinese character') returns 2

Oracle Product : Oracle Database Standard 19.3.0.0.0

Plateform : Windows 2019 x64

Database character set : AL32UTF8

According to my understanding, The function LENGTH always returns the number of characters in a string.

However, when i execute it against a Chinese character,

select length('𡘙') from dual;

it returns 2.

The result is also the same when it is selected from a table:

select length(column_name) from my_table;


Is there anything going wrong ?

Thank you for your help.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center