Here are the default result type and attributes for TRIM(string_expression):
| string_expression | Result Type |
|---|---|
| Byte string | VARBYTE |
| Numeric expression or character string | VARCHAR |
| Null | NULL |
The length of the result may be zero.
The server character set of the result is the same as the argument.