I am posting this to the General and JDBC groups so that it's in the
archive -- I know many people have had problems with Latin1 characters, and
I'd like to share what has worked for us. If anyone can add this
information to a more permanent FAQ, I'd be much obliged.
---
Using Postgres with
:
On Mon, 8 Nov 2004, J. Michael Crawford wrote:
Even in Java, where you can do all sorts of character-encoding
translation, it can be impossible to translate data retrieved from
Postgres
if it's in the wrong encoding. We've tried changing the JVM encoding,
altering the jdbc driver
anything that
covered all the bases. If there's a way to remove/correct/comment my
posting, I'm fine with that.
- Mike
At 04:55 PM 11/8/2004, Oliver Jowett wrote:
J. Michael Crawford wrote:
Encoding translations that didn't work:
a) Getting encoded bytes from the result set. We tried
In my experience, there are just some characters that don't want to be
converted, even if they appear to be part of the normal 8-bit character
system. We went to Unicode databases to hold our Latin1 characters because
of this. There was even a case where the client was cutting and pasting
Correction: Four things that need to be done, THREE if you're not
serving up html. Sorry for the editing error.
- Mike
At 01:19 PM 10/29/2004, J. Michael Crawford wrote:
In my experience, there are just some characters that don't want to be
converted, even if they appear to be part