Skip navigation
Contact Us
1134 Views 3 Replies Latest reply: Jan 24, 2013 4:09 PM by Info 2005 RSS
user ram Newbie 4 posts since
Jan 9, 2013
Currently Being Moderated

Jan 10, 2013 6:01 AM


My file has the below data


fursnishing`s design


but when i load using informatica it comes as below , please help on what are the changes need to be done before loading ?


fursnishing?s design

  • Venkat Byrapudi Master 976 posts since
    Mar 25, 2010
    Currently Being Moderated
    Jan 12, 2013 11:57 AM (in response to user ram)

    Where u are loading database(which one) or File?




  • Antony Praveen Raj Newbie 6 posts since
    Jan 13, 2013
    Currently Being Moderated
    Jan 13, 2013 6:36 PM (in response to user ram)

    If your source is a flat file then you need to edit the variable for code page in the .profile file in the unix server to get this issue resolved.

    • Info 2005 Novice 50 posts since
      May 16, 2012
      Currently Being Moderated
      Jan 24, 2013 4:09 PM (in response to Antony Praveen Raj)

      try below options,


      option1-Make sure code page is same in all places(src,tgt connection,in DB,in server..etc)


      option 2-



      CONVERT (FIELD,'utf8',  'WE8MSWIN1252' )


      Note :- This query will encode all the western European characters only to UTF-8.

More Like This

  • Retrieving data ...

Bookmarked By (0)