How to load special characters using MLOAD

Database
N/A

How to load special characters using MLOAD

Hello .. We have data coming in from an external source, and some of these records have special characters. When we try to MLOAD, the rows with special characters are being rejected. All fields are defined as VARCHAR. We would like to load the data as is, with the special characters. Any options ?? Thanks in advance.

 

.IMPORT INFILE ${SRC_DATA_FILE}
FORMAT VARTEXT '|'
DISPLAY ERRORS
nostop
LAYOUT IN_REC
APPLY INSERTS;
.end mload;

 

  • mload
  • Spechal Characters