Topic
  • 2 replies
  • Latest Post - ‏2010-11-18T07:53:21Z by Nithyab
Nithyab
Nithyab
2 Posts

Pinned topic Handling International Characters in Datastage like Japanese

‏2010-11-15T10:40:21Z |
Hi,

I need to handle out the Japanese characters in Datastage and UNIX , I don't know how exactly I have to use the NLS map in Datastage.Because after setting the NLS map as UTF-8 , I can able to see as ? or boxes in UNIX

Please assist me accordingly.

Regards
Nithya
Updated on 2010-11-18T07:53:21Z at 2010-11-18T07:53:21Z by Nithyab
  • sakurab
    sakurab
    1 Post

    Re: Handling International Characters in Datastage like Japanese

    ‏2010-11-16T12:13:38Z  
    Hi,

    This usually happens when the NLS map is not set according to the data.
    Your locale would be UTF-8 for linux, but is your data encoded in UTF-8 too?
    It seems as if your data is not UTF-8, but as you have set UTF-8 as the NLS for the file, and that is why you are getting "?" or garbled characters.
    (I am guessing that you are facing this problem with your input or output file.)
    Try to change the NLS map according to the encoding of the file.

    It maybe Shift-JIS, EUC or maybe some thing else...

    Regards,
    Sakura
  • Nithyab
    Nithyab
    2 Posts

    Re: Handling International Characters in Datastage like Japanese

    ‏2010-11-18T07:53:21Z  
    • sakurab
    • ‏2010-11-16T12:13:38Z
    Hi,

    This usually happens when the NLS map is not set according to the data.
    Your locale would be UTF-8 for linux, but is your data encoded in UTF-8 too?
    It seems as if your data is not UTF-8, but as you have set UTF-8 as the NLS for the file, and that is why you are getting "?" or garbled characters.
    (I am guessing that you are facing this problem with your input or output file.)
    Try to change the NLS map according to the encoding of the file.

    It maybe Shift-JIS, EUC or maybe some thing else...

    Regards,
    Sakura
    Hi ,

    Thanks for tthe response.

    Yes while viewing the input file or output file in UNIX/Datastage.

    The data is of UTF8 ASCII text format (International Characters),

    I hope we need to configure on UNIX first then with datastage

    Thanks Nithya