How to get the length of chineses string in teradata?

Member

by lily , in category: MySQL , 21 days ago

How to get the length of chineses string in teradata?

Facebook Twitter LinkedIn Telegram Whatsapp

1 answer

by edmond_brakus , 20 days ago

@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.