topic Re: Issue inserting non-Latin characters in a MySQL database in Talend Studio

Issue inserting non-Latin characters in a MySQL database

Anonymous — Sat, 16 Nov 2024 07:36:47 GMT

Hi,

I have an sql query like

Select * from table where message LIKE '%\'. This run well in oracle database. But when I put this query in talend tDBInput, it is not taking '\'. How do I make this query work in talend?

Can anyone help me out.

Thanks in advance,

Meghana.

Re: Issue inserting non-Latin characters in a MySQL database

Anonymous — Fri, 21 Sep 2018 13:53:17 GMT

This is because your SQL is in a Java String. This is why it needs "" around it. In Java the \ is an escape character. In order to use it as just a backslash, you need to escape it like below...

"Select * from table where message LIKE '%\\'"

Re: Issue inserting non-Latin characters in a MySQL database

Anonymous — Mon, 24 Sep 2018 07:38:38 GMT

Thanks..It worked.