The LENGTH() function

Informix^® provides the LENGTH() function:

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

Netezza^® has a equivalent function with the same name, but there is some difference:

Informix does not count the trailing blanks for CHAR or VARCHAR expressions, while Netezza counts the trailing blanks.
With the Netezza LENGTH function, values are always blank-padded when using a CHAR column, so the function returns the size of the CHAR column. When using a VARCHAR column, trailing blanks are significant, and the function returns the number of characters, including trailing blanks.

Solution

You must check if the trailing blanks are significant when using the LENGTH() function.

If you want to count the number of character by ignoring the trailing blanks, you must use the RTRIM() function: