Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Is there an UTF8 encoding type with BOM?

Hi,
several file-components like tFileInputDelimeted allow to set a custom encoding type like "windows-1252" or "UTF-8". Talend uses "UTF-8" without BOM. Is there an UTF8 encoding type with BOM?
Labels (2)
13 Replies
_AnonymousUser
Specialist III
Specialist III

Is there any anserer?
I'm wondering too.
Anonymous
Not applicable
Author

Hi,
There is an option "Custom" in Encoding part. But I'm not sure it can work well. We don't do that before and just use UTF-8 without bom. You can try to set the part as UTF bom. see pic
Best regards
Sabrina
Anonymous
Not applicable
Author

Hi,
Can you please post the settings for tFileOutputDelimited component UTF-8 with BOM encoding? The picture from the last post explaining the custom encoding settings is not available.
Thanks in advance
Michael
Anonymous
Not applicable
Author

Hi,
Here is a related forum: https://community.talend.com/t5/Design-and-Development/resolved-Encoding-issue-with-tfileOutputDelim...
Please see the pic
Best regards
Sabrina
0683p000009MD84.png
Anonymous
Not applicable
Author

Hi Sabrina,
I am receiving an unsupported encoding exception using "UTF-BOM".  Can you please confirm the string of the encoding type?

Starte Job J037_Gesamt am 10:28 22/09/2014.
connecting to socket on port 3508
connected
Exception in component tFileOutputDelimited_4
java.io.UnsupportedEncodingException: UTF-BOM
at sun.nio.cs.StreamEncoder.forOutputStreamWriter(Unknown Source)
at java.io.OutputStreamWriter.<init>(Unknown Source)
at prm.j037_konto_gesamt_csv_mgrenz_0_1.J037_Konto_Gesamt_CSV_MGRENZ.tFileInputDelimited_4Process(J037_Konto_Gesamt_CSV_MGRENZ.java:5197)
at prm.j037_konto_gesamt_csv_mgrenz_0_1.J037_Konto_Gesamt_CSV_MGRENZ.runJobInTOS(J037_Konto_Gesamt_CSV_MGRENZ.java:6774)
at prm.j037_konto_gesamt_csv_mgrenz_0_1.J037_Konto_Gesamt_CSV_MGRENZ.main(J037_Konto_Gesamt_CSV_MGRENZ.java:6616)
disconnected
Job J037_Konto_Gesamt endet am 10:28 22/09/2014.

Thanks in advance,
Michael
Anonymous
Not applicable
Author

Hi
There is an option "Custom" in Encoding part. But I'm not sure it can work well. We don't do that before and just use UTF-8 without bom. You can try to set the part as UTF bom

Have you also tried the solution in the related forum?
Best regards
Sabrina
Anonymous
Not applicable
Author

Have you also tried the solution in the related forum?


Yes, but I did not manage to install the tWriteHeaderLineToFileWithBOM component. The component does not appear in the palette.
Kind regards,
Michael
Anonymous
Not applicable
Author

Hi,
Actually, this is a custom component developed by talend community users.
You can get it from Talend Exchange Protal:

https://exchange.talend.com/#marketplacesearch:gallery=marketplace%252F1&ob=releaseDate&o=0&c=20&d=t...


then install it into talend studio TalendHelpCenter:Installing a custom component.
Best regards
Sabrina

Anonymous
Not applicable
Author

Hi Sabrina,
thank you for the links. I have installed the component, but I still have not managed to produce a file with BOM (see screenshot attached). It seems that the component does not write any BOM header line to the file. The review is making the same statement.
Can you please verify, how the component needs to be configured to make it work?
Thanks in advance,
Michael