Create UTF-8 CSV from Infromix GB chinese
Posted in 2009
Topics: Internationalization & Character Sets
Hi, I tried to load informix generated GB-simplified-chinese delimitied file to utf-8 db2 using codepage=1386 in db2 IMPORT statement. After the import with conversion, I could read chinese column fields correctly. However, the file contained some nonprintable/corrupted characters and caused some records conversion failed and the whole records were rejected. If I sticked to utf-8 codepage=1208, all records were imported with no rejection, but I couldn't read the chinese column field at my local windows pc db2 client browser, although I could see and list out the chinese words at unix db2 command prompt. So now I wonder if I could generate the informix delimited file in utf-8 in the first place, then could I import it to db2 without any conversion, and no record rejection will occur? The informix server is already in GB simplified chinese locale, how could I export the data and generate the delimited file in utf-8? Hope that I explain clearly and thank you for any help.