Обсуждение: latin1 -> unicode
hy I would like to convert my latin1 database (allready create with data inside....) in a unicode database. Can you help me?! Thanks Jules
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
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
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