[Feature][SDK] Transform SQL supports CHAR_LENGTH function

[Zkplo]

Description

• parent issue [Umbrella] Tencent Rhino-bird: Expand InLong Transform functions #10796
• MySql Official Description: https://dev.mysql.com/doc/refman/8.4/en/string-functions.html#function_char-length

CHAR_LENGTH(str): Returns the length of the string str, measured in code points. A multibyte character counts as a single code point. This means that, for a string containing two 3-byte characters, LENGTH() returns 6, whereas CHAR_LENGTH() returns 2

Use case

mysql> SET @dolphin:='海豚';

mysql> SELECT LENGTH(@dolphin), CHAR_LENGTH(@dolphin);
+------------------+-----------------------+
| LENGTH(@dolphin) | CHAR_LENGTH(@dolphin) |
+------------------+-----------------------+
|                6 |                     2 |
+------------------+-----------------------+
1 row in set (0.00 sec)

Are you willing to submit PR?

• Yes, I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct