Add a new JDBC parameter for Postgres

[Anonymous]

Hi everyone !
I've got a problem with my pretty integration process !
I have to integrate some data in a Postgres database but there is some encoding problems !
I read somewhere that I had to add a JDBC parameter like this : "charSet=ISO-8859-1", but I really don't know where I sould put it.

The problematic part of my process look a this ! (see the attached screen)
Thank you by advance !

[Anonymous]

First of all, check if the problem is actually the database. If it the case, you do not need such property. Take care the tables are created with the correct encoding setting. 

[Anonymous]

I run the job on my local machine and didn't met any encoding problem but when I run the job on a VM, there is encoding problem !
So I don't think that the problem comes from the DB...
I tried to force the chcp code in the console but it didn't change anything !
So, in my opinion, the only thing I can do is to force the encoding in the job !

[Anonymous]

FYI : I'm working on TOS 5.6 

[Anonymous]

 
Hi FloCAD,
Have you tried to add the parameter  "charSet=ISO-8859-1" to the JVM parameters to see if it  works?
 
Best regards
Sabrina

[Anonymous]

Ah thx a lot Sabrina ! It was what I was searching for !
But unhappily, when I run it, I obtain the following error code : "Erreur : impossible de trouver ou charger la classe principale charSet=ISO-8859-1"
(in English, it sound like : Error: Can not find or load the main class charSet = ISO-8859-1)

[Anonymous]

I tried : -Dfile.encoding="ISO-8859-15" (found  there) and the job ran but it didn't work to in the DB, the encoding problems were there again...
I start to give up...

Oh sorry ! I forgot to specify that, in Talend, with a tLogRow, I can visualise the data without encoding problem ! But in the console (with an exported job in .bat), this same tLogRow has encoding problems !
And in all cases, in the DB I always have encoding problems ...

[Anonymous]

Okay I finally found the solution !
For the others who have the same problem, juste follow those steps :
- go to C:\TOS\TOS_DI-Win32-20141207_1530-V5.6.1\plugins\org.talend.designer.components.localprovider_5.6.1.20141207_1530\components\tPostgresql[the different postgres component you use]\[the different postgres component you use].xml and set the parameter where the encoding SHOW="true" ! (now, you can modify the encoding dynamically in talend)
- Then, in your process, setup the encoding parameters in all [the different postgres component you use] 
- And then, put in the advanced settings of the JVM, the following parameter : -Dfile.encoding="ISO-8859-15"
Take care to always specify the same encoding a lot of time can lost some caracters !

[Anonymous]

Hi,

For the others who have the same problem, juste follow those steps :
- go to C:\TOS\TOS_DI-Win32-20141207_1530-V5.6.1\plugins\org.talend.designer.components.localprovider_5.6.1.20141207_1530\components\tPostgresql[the different postgres component you use]\[the different postgres component you use].xml and set the parameter where the encoding SHOW="true" ! (now, you can modify the encoding dynamically in talend)
- Then, in your process, setup the encoding parameters in all [the different postgres component you use] 
- And then, put in the advanced settings of the JVM, the following parameter : -Dfile.encoding="ISO-8859-15"
Take care to always specify the same encoding a lot of time can lost some caracters !

Thanks for your feedback and sharing your solution with us.
Best regards
Sabrina