Re: New database: SQL_ASCII vs UTF-8 trade-offs

--- 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