HPE NonStop SQL/MX Error – 4133 Both trim character and source have to be CHARACTER type.

In this blog post, let’s learn about the error message “4133 Both trim character and source have to be CHARACTER type.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

4133 Both trim character and source have to be CHARACTER type.

Reason for the Error

The type of the trim source and trim character is not CHARACTER.

Solution

Make sure the type of the source and trim character is CHARACTER