From: | "Laurent Schweizer" <laurent(dot)schweizer(at)peoplefone(dot)com> |
---|---|
To: | "'Dave Cramer'" <pg(at)fastcrypt(dot)com>, "'Kevin Grittner'" <kgrittn(at)ymail(dot)com> |
Cc: | <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | RE: [JDBC] Re: [JDBC] Re: [JDBC] é converted in Ã(c) |
Date: | 2013-02-09 09:48:54 |
Message-ID: | 004201ce06aa$ad15b110$07411330$@peoplefone.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
I think that Im correct with the client encoding as the SHOW
client_encoding return UTF8 no ?
Laurent
De : pgsql-jdbc-owner(at)postgresql(dot)org
[mailto:pgsql-jdbc-owner(at)postgresql(dot)org] De la part de Dave Cramer
Envoyé : samedi 9 février 2013 00:01
À : Kevin Grittner
Cc : Laurent Schweizer; pgsql-jdbc(at)postgresql(dot)org
Objet : [JDBC] Re: [JDBC] Re: [JDBC] é converted in Ã(c)
The JDBC driver only knows one encoding. Are you using it to retrieve the
data as well ?
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On Fri, Feb 8, 2013 at 5:52 PM, Kevin Grittner <kgrittn(at)ymail(dot)com> wrote:
Laurent Schweizer <laurent(dot)schweizer(at)peoplefone(dot)com> wrote:
> I have an issue with special character like é.
> I have as server postgres 9.2, I have created a new DB , encoding
> utf8
>
> Client is a very simple test class that:
> 1) update a varchar value
> 2) read the same value and print them
>
> If I update the varchar with a special character like é the
> value in the DB is correct ( I check them with another software )
> but when I read them from my simple java class the value is not
> correct and the é is converted in é
>
> I have added to the connection string the option:
> ?useUnicode=true&characterEncoding=utf8
>
> And if I do a : "SHOW client_encoding; I get UTF8
It is behaving as though the client is using a character encoding
other than UTF8 -- some sort of 8-bit encoding, probably. You must
set client_encoding to match.
-Kevin
--
Sent via pgsql-jdbc mailing list (pgsql-jdbc(at)postgresql(dot)org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jdbc
From | Date | Subject | |
---|---|---|---|
Next Message | Laurent Schweizer | 2013-02-09 09:53:31 | RE: [JDBC] é converted in é |
Previous Message | dmp | 2013-02-09 01:41:42 | Re: é converted in é |