ow <oneway_111@xxxxxxxxx> writes: > 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? It seems risky, but you could probably get away with that as long as the database locale (LC_COLLATE/LC_CTYPE) is "C" ... which is really the only one that's safe with SQL_ASCII anyway ... note that already-started backends will probably fail to notice such a change. regards, tom lane
