A characterExpression is a CHAR, VARCHAR, or LONG VARCHAR data type or any built-in type that is implicitly converted to a string (except a bit expression).
If the parameter type is CHAR or LONG VARCHAR, the return type is CHAR or LONG VARCHAR. Otherwise, the return type is VARCHAR.
The length and maximum length of the returned value are the same as the length and maximum length of the parameter.
If the characterExpression evaluates to null, this function returns null.