I have a Oracle and it's encoding is UTF-8. When I insert some non-English string into it, I'll get ORA-12899. I think the reason is some non-English needs 3 bytes in UTF-8 system.

The simplest solution is to extend the length of Oracle. I want to trim the string and I can't find a single solution to trim the string. Are there any suggestions? I tried to get the byte length but the value is not for UTF-8.