Specifying Arguments to the TRIM Function

The TRIM function is a built-in SQL function that removes leading or trailing pad characters from a character string. By default, this pad character is ASCII 32, the blank space. If your locale supports a code set that defines a different whitespace character, TRIM does not remove this locale-specific blank space from the front or back of a string. If you specify the LEADING, TRAILING, or BOTH keywords for TRIM, you can specify a different pad character.

You cannot, however, specify a non-ASCII character as a pad character, even if your locale supports a code set that defines the non-ASCII character.