--- Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > ow <oneway_111@xxxxxxxxx> 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