Re: PostgreSQL and character set change

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: Jayadevan M <Jayadevan(dot)Maymala(at)ibsplc(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: PostgreSQL and character set change
Date: 2009-12-23 07:42:22
Message-ID: 162867790912222342u42e9fc1egba038195c6d21592@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2009/12/23 Jayadevan M <Jayadevan(dot)Maymala(at)ibsplc(dot)com>

> 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 of the existing installation
> Please do provide some information on how to do this.
> Jayadevan
>

1 is right.

Regards
Pavel Stehule

>
>
> *
>
> DISCLAIMER:** *
>
> "The information in this e-mail and any attachment is intended only for the
> person to whom it is addressed and may contain confidential and/or
> privileged material. If you have received this e-mail in error, kindly
> contact the sender and destroy all copies of the original communication. IBS
> makes no warranty, express or implied, nor guarantees the accuracy, adequacy
> or completeness of the information contained in this email or any attachment
> and is not liable for any errors, defects, omissions, viruses or for
> resultant loss or damage, if any, direct or indirect."
>
>
>
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Albe Laurenz 2009-12-23 07:42:54 Re: PostgreSQL and character set change
Previous Message Robert Hodges 2009-12-23 06:25:20 Re: 11/10 SFPUG meeting, "Continuent Tungsten with PostgreSQL," video now available