Hello I'm transforming an XML file. The source file has umlaut characters which have been converted to their utf-8 equivalents. For example the source file contains: <TOWNCITY>Düsseldorf</TOWNCITY> When I transform this into an new XML format, TOS converts this to: <TOWNCITY>Düsseldorf</TOWNCITY> I would like to preserve the original, but I can't figure it out. Both the source and the output file are configured to be UTF-8 encoding. Any ideas how I can achieve this? Thanks for your help.
Hmmm.... the character has been converted in the post too. So the original should be: <TOWNCITY>D & # 2 5 2 ; sseldorf</TOWNCITY> With spaces, so that it does not convert
Hi Jonathan,
I think the output of the job should be in the format you specify in the output component. So if your input contains UTF-8 and you read this into Talend it will convert it to an internal format, but when exporting, you should be able to select the desired format again, UTF-8 for example. This should give you a file or table with the correct data.
Hope this helps.
Regards,
Arno
Arno
Thanks for the reply. I'm doing as you suggest - the source file is read as UTF-8 and the output I create is also UTF-8, but Talend is still converting the data to the umlaut character. Maybe its a bug - I can't find any configuration parameters that will change this.
Jonathan