Using Unicode Data in Dtastage Transformer

Rakesh311 · Post by **Rakesh311** » Fri Jun 01, 2012 10:03 pm

Hello All,

We have a requirement here to Convert data to the Unicode Greek letters.

For Example:

If input data='ohm' then 'Ω'

But when we type 'Ω' in transformer stage its showing as '?'.

Is there any way to do it with NLS setting or any other way to handle this

Thanks,
Rakesh K

ray.wurlod · Post by **ray.wurlod** » Sat Jun 02, 2012 5:44 am

Use an NLS map that includes Greek characters.

Tip: It's a subset of ISO8859.

Rakesh311 · Post by **Rakesh311** » Mon Jun 04, 2012 4:30 am

I got it!!!

When we used UTF -8 in the Output sequential file with output column as Unicode its giving the required output.

For which we have to use the function Char(Decimal value of the unicode character ) in the transformer.
ex:char(8486) for Ω

Regards,
Rakesh