From: Ivo Rossacher <rossacher@bluewin.ch>
To: pgsql-admin@postgresql.org
Subject: Re: Converting a DB from SQL_ASCII to UTF-8
Date: Mon, 18 Jun 2007 19:47:29 +0200
Message-ID: <200706181947.30614.rossacher@bluewin.ch> (raw)
In-Reply-To: <200706181636.20224@zmi.at>
References: <200706181636.20224@zmi.at>
There is no general answer to the question. It highly depends on how the data
was entered.
SQL_ASCII is not an encoding but more the absence of any encoding. So whatever
the client sends will be put into the database. So if you entered data with
different encodings from the client side (typically different clients on
different operating systems). What to do with the data depends highly on the
used encodings of the clients. If you are very lucky and all entries were
based on the same encoding you might run iconv or recode on the dump and
reload the corrected dump. Otherwise you will have to manually, with the help
of recode or iconv, adjust the dump.
If your server is once on UTF-8 the server will convert from and to the
encoding of your client for you. SQL_ASCII asks the server not to convert
anything.
Best regards
Ivo
Am Montag, 18. Juni 2007 16:36 schrieb Michael Monnerie:
> Dear list,
>
> how would I convert an existing database (dbmail mail server,
> http://dbmail.org/) from SQL_ASCII to UTF-8?
>
> I cannot just dump and reload, because:
>
> psql:/mnt/dbmail:191030: FEHLER: ungültige Byte-Sequenz für
> Kodierung »UTF8«: 0xdc62
> TIP: Dieser Fehler kann auch auftreten, wenn die Bytesequenz nicht mit
> der Kodierung übereinstimmt, die der Server erwartet, welche
> durch »client_encoding« bestimmt wird.
>
> (How could I tell postfix to speak with me in english?)
>
> Now what would be the correct way to convert, without destroying any of
> the DB contents? There are e-mails there, so binary values are
> important, too.
>
> mfg zmi
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 using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: rossacher@bluewin.ch
Subject: Re: Converting a DB from SQL_ASCII to UTF-8
In-Reply-To: <200706181947.30614.rossacher@bluewin.ch>
* 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