NLS UTF-8 conversion problem

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

If the AS/400 character set is 8859-1 then you cannot store and display that character. If the character set used is another one and the 8859-1 is just used for the interface then you should be OK by specifying another character set, as the AS/400 will perform the appropriate conversion to the internal EBCDIC set.
muralidwhds
Participant
Posts: 39
Joined: Sat Jul 05, 2008 3:25 am
Location: chennai

Post by muralidwhds »

The same NLS conversion happen to me today

am loading data from db2 database with NLS map MS1252-CS into SQL Server Database with sma NLS map MS1252-CS so job has thrown the below error.

Unmappable characters found mapping text string with this characteres: “ characters

so please suggest me how can i rectify this one.
MALLI MURALI
Post Reply