Обсуждение: latin1 -> unicode

Поиск
Список
Период
Сортировка

latin1 -> unicode

От
Jules Chalier
Дата:
hy

I would like to convert my latin1 database (allready create with data
inside....) in a unicode database.
Can you help me?!
Thanks

Jules

Re: latin1 -> unicode

От
Holger Klawitter
Дата:
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@klawitter.de

Re: latin1 -> unicode

От
Joseph Shraibman
Дата:
Holger Klawitter wrote:
> 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").

After each \connect

Re: latin1 -> unicode

От
"Al-Karim Bhamani (LCL)"
Дата:
How do you set encoding in pgadmin

-----Original Message-----
From: Joseph Shraibman [mailto:jks@selectacast.net]
Sent: Monday, May 26, 2003 2:36 PM
To: Holger Klawitter
Cc: Jules Chalier; pgsql-general@postgresql.org
Subject: Re: [GENERAL] latin1 -> unicode

Holger Klawitter wrote:
> 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").

After each \connect


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster