Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am building some metadata for transformation of CSV/TXT files that includes arabic in the windows-1256 char set, but could not figure out how to add this support to Talend Studio.
Attached screenshot is what I have right now.
I have done some searches in the community pages, but can't seem to find any recent discussion on this, so I expect I am missing something glaringly obvious!
The second part is, assuming I get pass the above hurdle, is translating it to UTF-8. Will tMap do this ?
Text file is from MsAccess text file export.
I am using version 7.1 on MacOS Mojave.
Appreciate any help.
Thanks
What is the flow ?
Are you trying to load the txt file with arabic languages to a database / another text file?
Hi,
Basically yes. The text file with the Arabian text will be uploaded to a MySQL database. It will later be pulled as part of a web page and reporting.
Hi,
Could you please select UTF-8 encoding in Talend components for your use case? I would also suggest to cross verify the language set of your database also to make sure that data is retained in right format within DB.
If you are facing any issue, could you please share the job flow with component details (of the component which is giving error) so that we can do detailed analysis?
If the answer has helped to resolve your query, could you please mark the topic as resolved? Kudos are also welcome 🙂
Warm Regards,
Nikhil Thampi
Hi,
I think you are thinking of a different problem. I am trying to create a metadata structure for data that uses Windows-1256 Character Set.
This represents the input metadata. I know that UTF-8 is supported in the output.
Thanks
Saif_dev