Jump to: navigation, search

Mysql CHARACTER LENGTH

From w3cyberlearnings

Contents

MySQL CHARACTER_LENGTH Function

This function is a synonym for CHAR_LENGTH() function. This function is not the same as LENGTH() function.

Syntax CHARACTER_LENGTH

  • Str: A String input
CHARACTER_LENGTH(Str);

Example 1


mysql> SELECT CHARACTER_LENGTH('good old'),CHAR_LENGTH('good old');
+------------------------------+-------------------------+
| CHARACTER_LENGTH('good old') | CHAR_LENGTH('good old') |
+------------------------------+-------------------------+
|                            8 |                       8 | 
+------------------------------+-------------------------+
1 row in set (0.01 sec)


Related Links


Navigation
Web
SQL
MISC
References