Обсуждение: é converted in é

Поиск
Список
Период
Сортировка

é converted in é

От
"Laurent Schweizer"
Дата:

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

Re: [JDBC] é converted in é

От
Kevin Grittner
Дата:
Laurent Schweizer <laurent.schweizer@peoplefone.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