Naz Gassiep <naz@xxxxxxxx> 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