Handling special characters

[Anonymous]

Hello 

I have a job that copy data from table A to table B but the issues is that some special characters are been modified when I run the job.

My Table A contains data encrypted using mysql function aes_encrypt . 

So I export my two tables and i have found that some special characters are not the same.

I'm using DEFAULT CHARSET=latin1. And after some research I found this solution: 

Add encoding to projectsettings : %~d0 cd %~dp0 java -Dfile.encoding=utf-8 ${talend.job.jvmargs} -cp ${talend.job.bat.classpath} ${talend.job.class} ${talend.job.bat.addition} %*

but this solution does not work.