HPE NonStop SQL/MX Error – 20042 Importing binary data to UCS2 character column columnname is not allowed.

In this blog post, let’s learn about the error message “20042 Importing binary data to UCS2 character column columnname is not allowed.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

20042 Importing binary data to UCS2 character column columnname is not allowed.

Reason for the Error

You attempted to import UCS2 character data in binary mode.

Solution

Prepare the UCS2 data in a UCS2 data file and import it in delimited mode