How can I get the string.length meet Oracle system requirement when the string contains both chinese characters and english characters?

[Yoichi]

Hi,

It’s duplicated post… I replied the following post, FYI.

How can get substring when the string have both Chinese characters and English characters to meet Oracle requirements?

Hi, Is the encoding UTF-8? in UTF-8, Chinese character is usually encoded as 3 bytes but not always. So we need to evaluate actual byte length, I think. Can you try the following expression? [img20211221-5] yourString.Substring(0,Enumerable.Range(0,maxLimit).Where(Function(i) System.Text.Encoding.GetEncoding("UTF-8").GetBytes(yourString.Substring(0,i)).Length<maxLimit).Max) If your encoding is not UTF-8, please modify it to your encoding. Regards,

Regards,