I need to store a product code in English & a product description in Chinese on an AS400 database file.
I have the data on a spreadsheet & need to upload it to the AS400
I've created a physical file with a field defined with a data type of E (see below).
A R ITMTSTR
A TEXT('TEST ITEM FILE')
A ITPROD 20 TEXT('ENGLISH PRODUCT CODE')
A ITCDES 80E TEXT('CHINESE DESCRIPTION')
A K ITPROD
I inserted a row using iSeries navigator & copy & pasted the data from the first line of the spreadsheet
The Chinese characters show up as squares in the row & when I try and save it I get an error
"Column 2: CWBNL0107 - Converted 4 bytes, 2 errors found beginning at offset 0"
Does anyone know what I need to do to get the Chinese characters onto my AS400 data file.