Problem with Accented characters in Lookup

mydsworld · Post by **mydsworld** » Tue Dec 11, 2007 2:18 am

Can anyone please let me know how we deal with accented characters in DataStage. I am reading a .csv file (containing accented characters) in Sequential File stage with NLS_Map set to 'ISO-8859-1' and individual columns having the extended 'Unicode' property.When I view the data I can see those accented characters.

Now I am using this file for lookup as reference link. In the output file I find those characters replaced by '?' etc. Within Lookup stage I am using NLS_Locale 'OFF' and in output sequential file I am using NLS_Map 'ISO-8859-1' and individual columns having the extended 'Unicode' property.

Please let me know why this is happening and which NLS_Locale should I select for Lookup stage.

Thanks in advance.