topic Re: How to set Talend client encoding for jdbc use? in Installing and Upgrading

How to set Talend client encoding for jdbc use?

Anonymous — Sat, 16 Nov 2024 14:38:13 GMT

Hi,

When I try to import data from mdb file to Postgres database the following error appears cause some rows have characters with accent ('è', 'é', 'à') .

DBD::Pg::st execute failed: ERROR:  invalid byte sequence for encoding "UTF8": 0xe87265
can't execute insert query

Postgres database encoding is 'UTF8' whereas Mdb file encoding seems to be 'ISO-8859-15'. ODBC is used to read mdb file while JDBC is used to connect to postgres. Can we say to postgres what encoding is used for sent data? I know that jdbc provide a "charSet" parameter but I did not know how to use it with Talend.
Does somebody has an idea of how to set client encoding within Talend? 😕
Thanks,
Matthieu (TOS newbie )

Re: How to set Talend client encoding for jdbc use?

Anonymous — Wed, 13 Dec 2006 12:20:51 GMT

Only MySQL connection encoding is modified when encoding is set to UTF-8. We have to do it also for PostgreSQL. I don't know yet how to do this, I'll search PostgreSQL documentation. Can you create a bug entry for this?

Re: How to set Talend client encoding for jdbc use?

Anonymous — Wed, 13 Dec 2006 16:18:42 GMT

Hi,
in PostgreSQL it is possible to set the client decoding to a different charset than the server. Maybe you can use this.
See section -> 20.2.3. Automatic Character Set Conversion Between Server and Client:
http://www.postgresql.org/docs/8.0/interactive/multibyte.html

Re: How to set Talend client encoding for jdbc use?

Anonymous — Thu, 14 Dec 2006 09:30:48 GMT

I read this post too which talk about client decoding but here we cannot use this cause, if I understood, it is applied for all client connections...
I don't think our DBA likes it
So to answer Plegall, I will create a bug entry.
Thanks for your answers,
Matthieu

Re: How to set Talend client encoding for jdbc use?

Anonymous — Fri, 15 Dec 2006 22:00:29 GMT

Hi,
I'm sorry. I didn't know that the link was already posted. But you can use a SQL command in PostgreSQL to set the client session encoding, that is only valid for the session you're using. So you won't be making your DBA angry. In the PostgreSQL list archives sombody did I nice post about it.
Mayby you can use or test it:
http://archives.postgresql.org/pgsql-jdbc/2004-11/msg00075.php
He uses the SQL command: SET CLIENT_ENCODING TO Latin1
I hope this helps a little bit.

Re: How to set Talend client encoding for jdbc use?

Anonymous — Wed, 27 Dec 2006 14:12:02 GMT

Hi,
The bug has been fixed today (see 372).
Thank you very much Plegall for you reactivity It works!
Matthieu

Re: How to set Talend client encoding for jdbc use?

BathSeal — Fri, 24 Jul 2020 07:24:02 GMT

I didn't know that the link was already posted. But you can use a SQL command in PostgreSQL to set the client session encoding, that is only valid for the session you're using. TelltheBell