Output CSV file in UTF-16 Little Endian

Highlighted
One Star

Output CSV file in UTF-16 Little Endian

Hi there,
I'm required to output a csv file from a Talend ETL process in UTF-16 Little Endian. It seems that for the tFileOutputDelimited component when I enter "UTF-16" under advanced settings for customer encoding it only outputs a Big Endian csv file which gets rejected by another ETL pipeline (unless it's in Little Endian).
How can I output a CSV file in UTF-16 Little Endian in the customer encoding part of the tFileOutputDelimited component?
Thanks
Facoda
Seventeen Stars

Re: Output CSV file in UTF-16 Little Endian

It is not implemented yet. Nevertheless it is possible be creating you own output row. You have to rely heavily in Java.
I have found solutions in stackoveflow and you should be able to adapt than in Talend. 
Moderator

Re: Output CSV file in UTF-16 Little Endian

Hi,
Feel free to create a new feature issue on Talend Bug Tracker for your requirment.
https://jira.talendforge.org/secure/Dashboard.jspa

Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

Cloud Free Trial

Try Talend Cloud free for 30 days.

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.