Re: problem: Postgresql and Unicode

From: Björn Metzdorf <bm(at)turtle-entertainment(dot)de>
To: "Nathalie Boulos" <nathalieboulos(at)hotmail(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: problem: Postgresql and Unicode
Date: 2003-02-22 10:08:37
Message-ID: 015f01c2da5a$5ed64e10$0564a8c0@shock
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> But now I'm facing another problem:
> How do I convert existing data in an SQL_ASCII database to unicode?
>
> Has anyone tried this before?

Yes, that is no problem. Have a look at
http://www.postgresql.org/docs/view.php?version=7.3&idoc=1&file=multibyte.ht
ml#AEN21920

short: dump sql_ascii, create unicode db, insert the dump with client
encoding set to latin1 (or whatever).

Regards,
Bjoern

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Laurette Cisneros 2003-02-22 16:42:26 Re: server won't shutdown
Previous Message Nathalie Boulos 2003-02-22 08:51:31 Re: problem: Postgresql and Unicode