From: Peter Eisentraut <peter_e@gmx.net>
To: Scott Eade <seade@backstagetech.com.au>
Cc: pgsql-admin@postgresql.org
Subject: Re: Converting from LATIN1 to UNICODE encoding?
Date: Wed, 21 Sep 2005 16:15:21 +0200
Message-ID: <200509211615.22306.peter_e@gmx.net> (raw)
In-Reply-To: <433116DF.7050108@backstagetech.com.au>
References: <433116DF.7050108@backstagetech.com.au>
Am Mittwoch, 21. September 2005 10:16 schrieb Scott Eade:
> Is it necessary for me to convert the database to some other encoding
> (e.g. UNICODE) before I can store non-LATIN1 characters or does
> PostgreSQL catch these and encode them somehow?
Yes and no.
> I have actually been attempting to convert a database by doing a pg_dump
> (from the LATIN1 database) followed by a pg_restore (to one created with
> the UNICODE encoding).
That is the right method.
> Seemed to work with a sparsely populated 8.0.3
> database, but I am running into all sorts of problems with 7.3.10 (e.g.
> corrupted database followed by corrupted pg_clog).
That is the symptom of a different, much bigger problem. Encoding problems
certainly never corrupt the clog.
> What about JDBC, how does it know the encoding of the data I throw at
> it?
That depends on where your throws come from. As you surely know, Java mostly
uses Unicode internally, so the data sent by the JDBC driver to the database
is in Unicode, but as to what encoding the data that you input into your Java
program has, you need to sort that out with the Java library functions that
you use to read that data.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: peter_e@gmx.net, seade@backstagetech.com.au
Subject: Re: Converting from LATIN1 to UNICODE encoding?
In-Reply-To: <200509211615.22306.peter_e@gmx.net>
References: <433116DF.7050108@backstagetech.com.au> <200509211615.22306.peter_e@gmx.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox