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.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables