@lily
To get the length of a Chinese string in Teradata, you can use the CHARACTER_LENGTH function. Here is an example query to demonstrate how to get the length of a Chinese string:
SELECT CHARACTER_LENGTH('你好世界') AS string_length;
This query will return the length of the Chinese string '你好世界', which is 4 characters. You can replace '你好世界' with your own Chinese string to get the length of that string.