Обсуждение: é converted in é
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
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