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