Naz Gassiep <naz(at)mira(dot)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