I would like to encode in Encoding UTF-8 and ISO-8859 because all characters in data with accent (é ; à ; è ; etc.) = "?"
I saw that we can change in advanced settings but i don't have...
Someone can help me ?
Version of Talend :Talend Open Studio for Data IntegrationVersion: 6.3.1
Thanks TRF for your answer.
Can I force encoding in the database connectors ?
I use 2 databases connectors : firebird and General JDBC (Microsoft Azure).
If you are having trouble with charsets, you can try fixing this using a bit of Java.
String broken_nordic = "HÃ¤r Ã¤r nÃ¥gra merkkejÃ¤"; byte bytes = broken_nordic.getBytes("ISO-8859-1"); String fixed_nordic = new String(bytes,"UTF-8");
This *should* produce the following text .....
"Här är några merkkejä"
Test it and if that works you can create a reusable routine to make it easier to use
The SQL Server uses SQL_Latin1_General_CP1_CI_AS charset but I don't understand when I insert directly rows it takes into account special characters ...
I think the unique solution is to create a new database with adequate charset.