Handling Simplified Chinese with DataStage NLS

dhwankim · Post by **dhwankim** » Tue Apr 13, 2004 1:13 am

Hi Gurus.

I have a problems with handling Simplified Chineses with DataStage.
Actually DataStage is installed on Korean UNIX Server with NLS KSC5601.

My Default Character map is KSC5601. But I need to extracet Chineses Data from Remote ORALCE.
They(Chinese DBA) said their ORACLE is setup with NLS ZHS16GBK.
but I could not find that map in DataStage.
So I tried to extract their data with NLS MP936. but It seems wrong encoding with Chineses data.

And Second thing is , If I use datastage with NLS None, make also wrong encoding. I could not understand why datastage try to encode with NLS NONE.

PLS Help Me
Thanks in Advance.

DHwankim From Korea.

ray.wurlod · Post by **ray.wurlod** » Tue Apr 13, 2004 4:07 pm

DaeHwan,

The NONE map is correctly used with hashed files, because these are already "inside" DataStage, so any data in them have already been mapped.

The only simplified Chinese map supplied with DataStage is GB 2312 (for UNIX) or MS936 (for Windows). You've stated that you're on UNIX, but have tried to use the Windows map.

It is possible to create your own maps, details of how to do this are in the UniVerse NLS Guide, which you can download from IBM's website (http://www-306.ibm.com/software/data/u2 ... ls/NLS.pdf)

You might also contact Ascential support, who (as you know) have great experience with NLS maps for DataStage.

Regards,
Ray