Spanish Characters in .csv file to load in Oracle DB table-Talend Studio

[Peram900]

We are facing an issue with a file which has Spanish characters, while loading in to Oracle DB using Talend Studio.

We would like to pass through the data as it is in to end table.

I have attached few example of data in attachment.

[Shicong_Hong]

Hello @Peram900 

What is the problem? Is it a garbled problem? If you got any error during the job execution, please paste the full track error messages. Thank you!

Regards

Shicong

[jlolling]

Your file should use the character set UTF-8 to be able to contain spanish special chars.

Take care you set this also as encoding in the tFileInputDelimited component.

The Oracle database can handle very well UTF-8 characters.

[Peram900]

Thanks, your reply-

We have file validation application; it validates all types of files. The process using common tFileInputDelimited component (using context parameter to catch the file name, field names,etc and load into temporary Oracle table). I have to set up-tFileInputDelimited to work for all encoding types -files. There I'm struggling to implement.