é converted in é - Mailing list pgsql-jdbc

From Laurent Schweizer
Subject é converted in é
Date
Msg-id 002d01ce063b$7be0f2e0$73a2d8a0$@peoplefone.com
Whole thread Raw
Responses Re: [JDBC] é converted in é
List pgsql-jdbc

Dear all,

 

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

 

I check on the network side and the é is correctly encoded in UTF-8

 

Any idea why the é is converted in é ?

 

I use the last version of the JDBC driver.

 

Thanks and regards

 

Laurent

pgsql-jdbc by date:

Previous
From: dmp
Date:
Subject: Re: Timestamp vs. Java Date/Timestamp
Next
From: Kevin Grittner
Date:
Subject: Re: [JDBC] é converted in é