Re: Changing DB Encodings

Naz Gassiep <naz@mira.net> writes:
> OK I understand now, I think. How do I check what locale is currently
> set?

"show lc_collate" (maybe check the other lc_ settings too for luck).

> I've successfully created a utf8 database, does that imply that
> because I was able to create a DB with a different encoding to the ones
> all the others use (SQL_ASCII) that my locale is set to "C" ?

No, that implies a lack of error checking.

            regards, tom lane