german special character does not appear correctly in DB2

chulett · Post by **chulett** » Fri Nov 07, 2014 8:18 am

What code page / characterset is your target database using?

ruf888 · Post by **ruf888** » Fri Nov 07, 2014 9:40 am

The DB2 colleague told me that the target db uses the IBM500 codepage. but If I use this in the job property, the job won't read any lines from the text file, because it can not find the delimeter in the file. So I can not use this code page.

chulett · Post by **chulett** » Fri Nov 07, 2014 9:47 am

Not sure how that would cause that... what is your record delimiter? Something unusual?

ruf888 · Post by **ruf888** » Fri Nov 07, 2014 11:09 am

No, the delimeter is comma. If I use the normal code page, like ISO-8859, utf-8, windows-1252, then the same job will run without error, but the character appears like I mentioned, not as I'd like to have.

chulett · Post by **chulett** » Fri Nov 07, 2014 11:15 am

So a field delimiter rather than a record delimiter issue. Odd.

chanaka · Post by **chanaka** » Mon Nov 10, 2014 4:49 am

Hi ruf888,

What is the data type of the column in target? Ideally it should be Nvarchar or Nchar to support multi-byte characters.

Cheers!

Chanaka