UTF-8 to ISO-8859-1 conversion

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
nnes
Participant
Posts: 14
Joined: Mon Sep 12, 2005 1:10 pm

UTF-8 to ISO-8859-1 conversion

Post by nnes »

I've got a nvarchar in SQL Server (reads work with UTF-8) and want to output it to ISO-8859-1. Unfortunately not all UTF-8 characters can be represented in ISO-8859-1, so I get 50 warnings and the job aborts. Is there a way to make a best effort conversion and just replace "non-western" characters with blanks?
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”