MySQL CHAR_LENGTH() alternative in IBM DB2 I have a value in a cell that has a Unicode character:

"Nit€sh"

I want to get the length in SB2. 
The problem is, If I use the length function it's considering '€' as 2 and total is 7. I am trying to achieve a total of 6 in this case.

EXAMPLE
In MySQL we had char_length() to address this. 

Is there anything similar in DB2?
This page explains how to deal with string lengths when Unicode characters are involved.

CHARACTER_LENGTH is the function you need.

CHARACTER_LENGTH(yourstring,CODEUNITS32);