topic Re: Handle Unicode String datatype in Talend Studio

Handle Unicode String datatype

mani1304 — Fri, 19 Jul 2019 05:19:39 GMT

Hi,

I have jobs, where the datatype is unicode string, that I can handle in ab initio DML having string as data type and unicode as character set, but I don't see any such datatype handling situation in talend, can someone suggest to handle it.

It seems data has space in between letter but it is actually not space, so can't replace space with blank in it. below is one example.

8 7 7 2 5 0 5 8 2 3

Re: Handle Unicode String datatype

Anonymous — Fri, 19 Jul 2019 15:35:02 GMT

Hi,

Please refer the below posts which is marked as resolved. I hope they will give you the way forward.

https://community.talend.com/t5/Design-and-Development/resolved-Encoding-to-UTF-8-miss-all-latin-special-characters/td-p/105820

https://community.talend.com/t5/Design-and-Development/resolved-problem-with-tMysqlOutput-and-Encoding/td-p/73824

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: Handle Unicode String datatype

mani1304 — Sat, 20 Jul 2019 03:32:14 GMT

Thanks Nikhil. but it doesn't have my answer.

I found below command on net to remove unprintable unicode letters and it is working on current dataset, which has less data, but I am not sure if this is correct and will work on everything.

replaceAll("\\p{C}","")