Re: New database: SQL_ASCII vs UTF-8 trade-offs - Mailing list pgsql-admin

From ow
Subject Re: New database: SQL_ASCII vs UTF-8 trade-offs
Date
Msg-id 20060307154859.55607.qmail@web53903.mail.yahoo.com
Whole thread Raw
In response to Re: New database: SQL_ASCII vs UTF-8 trade-offs  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: New database: SQL_ASCII vs UTF-8 trade-offs  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin

--- Tom Lane <tgl@sss.pgh.pa.us> wrote:

> ow <oneway_111@yahoo.com> writes:
> > Are there any negative effects related to the selection of UTF-8 over
> SQL_ASCII
>
> There will be a speed penalty; whether it's significant in your
> application is something you can only determine by experiment.

I see... If *ALL* data is in ASCII, is it possible to just update
"pg_database.encoding" to UTF-8 or will I need to recreate the db?

Thanks







__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

pgsql-admin by date:

Previous
From: "Andy Shellam"
Date:
Subject: Re: VACUUM Error?
Next
From: Tom Lane
Date:
Subject: Re: New database: SQL_ASCII vs UTF-8 trade-offs