| From: | rohano <rohano(at)freenet(dot)de> |
|---|---|
| To: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | JDBC encoding |
| Date: | 2003-05-25 21:38:44 |
| Message-ID: | 3ED137E4.9020000@freenet.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
I experienced the same problems as you with spezial german characters
called 'Umlaute'. Everything worked fine with postgres7.1 and JDBC using
"sql-ascii".
After changing to postgres 7.3 setting of driver option 'charset=LATIN1'
had no effect.
Reading the thread helped me a lot to understand the problem. My
workaround for now:
I dumped the database (with pg_dump, not pg_dumpall) to a file, then
dropped the database and createdan empty one with the former name by
sql-command with encoding = LATIN1. After restoring the data into the
database by copy from dump I really had both: Access from JAVA as well
as ODBC both with correctly shwn characters.
Time needed for that operation about 2 minutes. If you are in a hurry
this might be a quick solution.
Bye
rohano
| From | Date | Subject | |
|---|---|---|---|
| Next Message | yxy | 2003-05-26 00:19:37 | unsuscribe |
| Previous Message | Paul Thomas | 2003-05-23 17:38:39 | Re: No response after running an attempted database connect. |