What MySQL CHAR_LENGTH() function returns if no parameter is provided to it?

MySQLMySQLi Database

In this case, it means we are providing an empty string as an argument to the CHAR_LENGTH() function. It will return 0 on providing empty string because there are no characters to be counted by CHAR_LENGTH() function.

Example

mysql> Select CHAR_LENGTH('');
+-----------------+
| CHAR_LENGTH('') |
+-----------------+
| 0               |
+-----------------+
1 row in set (0.00 sec)
raja
Published on 19-Feb-2018 13:24:48
Advertisements