Special character Handling

WoMaWil · Post by **WoMaWil** » Fri Sep 26, 2008 9:04 am

Dear Senthi,

it is not as simple as you thing. The letters you mention should work without special NLS-settings in DataSTage.

You have first to look at source and target and if both of them are able to catch the letters.

Where do you get your data from and where do you want to leave them?

samsuf2002 · Post by **samsuf2002** » Sat Sep 27, 2008 4:03 am

What is your target ?, if it is a file then you can pass it through another transformer and put a constraint to capture ?s for that column and reject it.

ArndW · Post by **ArndW** » Sat Sep 27, 2008 4:07 am

Approach the problem step-by-step, as Wolfgang has suggested. What is your source character set? What character set would you like as your target?

senthilmp · Post by **senthilmp** » Mon Sep 29, 2008 7:42 am

Hi, Thanks for your response.
The source and target character set are of NLS UTF-8 setting. And i want the special characters which is not processed to capture in the Reject file, then only we can correct it and re process again.

senthilmp · Post by **senthilmp** » Mon Sep 29, 2008 11:02 pm

No these characters are not accepted by UTF-8 Coding, these are converted as '?????' and written into target, thats the problem i am getting.