Re: latin1 -> unicode

From: Holger Klawitter <lists(at)klawitter(dot)de>
To: Jules Chalier <jchalier(at)informactis(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: latin1 -> unicode
Date: 2003-05-25 10:32:21
Message-ID: 200305251227.31030.lists@klawitter.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Am Donnerstag, 22. Mai 2003 11:15 schrieb Jules Chalier:
> hy
>
> I would like to convert my latin1 database (allready create with data
> inside....) in a unicode database.

It should work like this:

* Dump the Database (pg_dump)

* Put "\encoding latin1" into the dump. (Not sure where, probably once
at the beginning or maybe after each "\connect"). This makes the restore
process considering following data as latin1. The database will take care of
converting it into the native unicode.

* Create the new Database with Unicode encoding (createdb -E unicode)

* Read the dump with psql into the new database.

Mit freundlichem Gruß / With kind regards
Holger Klawitter
--
lists(at)klawitter(dot)de

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Nigel J. Andrews 2003-05-25 10:48:03 Re: Hello (PGDATA question)
Previous Message Wayne Armstrong 2003-05-25 10:12:32 Re: Slashdot: SAP and MySQL Join Forces