Problem with Accented characters in Lookup
Posted: 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.
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.