Re: [GENERAL] PostgreSQL and character set change

2009-12-23 Thread Jayadevan M
: 12/23/2009 01:12 PM Subject: Re: [GENERAL] PostgreSQL and character set change Sent by:pgsql-general-ow...@postgresql.org Jayadevan M wrote: > We have a PostgreSQL server with ASCII data. We have a > requirement for the db to support UTF also. Which is the best >

Re: [GENERAL] PostgreSQL and character set change

2009-12-22 Thread Albe Laurenz
Jayadevan M wrote: > We have a PostgreSQL server with ASCII data. We have a > requirement for the db to support UTF also. Which is the best > approach - > 1) Make a new installation, move data This is the only and hence the best approach. It doesn't have to be a new installation, a new databa

Re: [GENERAL] PostgreSQL and character set change

2009-12-22 Thread Pavel Stehule
2009/12/23 Jayadevan M > Hi all, > We have a PostgreSQL server with ASCII data. We have a requirement for the > db to support UTF also. Which is the best approach - > 1) Make a new installation, move data > 2) There is some way of doing an 'in-place' conversion and changing the > character set o