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

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

Peram900 — Mon, 22 Jul 2024 19:12:42 GMT

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.

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

Shicong_Hong — Tue, 30 Jul 2024 07:57:13 GMT

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

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

jlolling — Wed, 31 Jul 2024 10:25:21 GMT

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.

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

Peram900 — Fri, 02 Aug 2024 03:31:25 GMT

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.