pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Scott Eade <seade@backstagetech.com.au>
To: pgsql-admin@postgresql.org
Subject: Converting from LATIN1 to UNICODE encoding?
Date: Wed, 21 Sep 2005 18:16:31 +1000
Message-ID: <433116DF.7050108@backstagetech.com.au> (raw)

I have a database that was created using the LATIN1 encoding.

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?

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).  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).

What about JDBC, how does it know the encoding of the data I throw at
it?  I guess I should ask this last question on the JDBC list.

Thanks in advance for any comments.

Scott



view thread (3+ messages)  latest in thread

Message-ID: <433116DF.7050108@backstagetech.com.au>
Permalink:  ../433116DF.7050108@backstagetech.com.au/
Also on:    postgresql.org/message-id/433116DF.7050108@backstagetech.com.au

 · 

reply

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: seade@backstagetech.com.au
  Subject: Re: Converting from LATIN1 to UNICODE encoding?
  In-Reply-To: <433116DF.7050108@backstagetech.com.au>
  References: <433116DF.7050108@backstagetech.com.au>

* 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