The LENGTH() function


Informix provides the LENGTH() function to count the number of bytes of a character string expression:

SELECT LENGTH("aaa"), LENGTH(col1) FROM table 

Informix LENGTH() does not count the trailing blanks for CHAR or VARCHAR expressions, while Oracle counts the trailing blanks.

Informix LENGTH() returns 0 when the given string is empty. That means, LENGTH('')=0.

Oracle® MySQL

MySQL supports the LENGTH() function, which is similar to Informix LENGTH().

The MySQL LENGTH() function ignores trailing blanks.

When passing NULL as parameter, the MySQL LENGTH() function returns NULL.


The SQL LENGTH() function name can be used with MySQL.