| From: | Boris Klug <boris(dot)klug(at)control(dot)de> |
|---|---|
| To: | Barry Lind <blind(at)xythos(dot)com> |
| Cc: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Re: Character encoding problem |
| Date: | 2003-02-14 09:48:55 |
| Message-ID: | 200302141048.55708.boris.klug@control.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
Hello!
> > OK, so I created the db using "initdb -E LATIN1" which does not helped.
> > Using "initdb -E UNICODE" will give even more problems: I wasnt able to
> > insert umlauts using psql...
OK, I retested the whole stuff, here a quick summay:
1) Using "initdb -E LATIN1" when creating a database.
Works great, that was the trick: I can now use pg73b1jdbc2, pg73rc1jdbc2 or
pg73jdbc2.
2) Using "initdb" (leads to encoding "SQL_ASCII":
I can retrieve umlauts when I use use the pg73b1jdbc2 driver with the option
"charSet=ISO_8859_1" in the JDBC connection url. That is what we used till
now - I think we have to switch to LATIN1 enconding when we migrate to 7.3.1
(from 7.2).
I was using PostgreSQL 7.3.1, running on Linux with JDK 1.4.
--
Dipl. Inform. Boris Klug, control IT GmbH, Germany
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jonathan Teague | 2003-02-14 14:55:31 | PostgreSQL JDBC Drivers licensing? |
| Previous Message | Carl Olivier | 2003-02-14 08:00:39 | Database Instance creation |