Issue inserting non-Latin characters in a MySQL database

[Anonymous]

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.

[Anonymous · Accepted solution]

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 '%\\'"

[Anonymous]

Thanks..It worked.