Page 1 of 1

Using Unicode Data in Dtastage Transformer

Posted: Fri Jun 01, 2012 10:03 pm
by Rakesh311
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

Posted: Sat Jun 02, 2012 5:44 am
by ray.wurlod
Use an NLS map that includes Greek characters.

Tip: It's a subset of ISO8859.

Posted: Mon Jun 04, 2012 4:30 am
by Rakesh311
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