Re: Changing DB Encodings - Mailing list pgsql-general

From Tom Lane
Subject Re: Changing DB Encodings
Date
Msg-id 14247.1183849935@sss.pgh.pa.us
Whole thread Raw
In response to Re: Changing DB Encodings  (Naz Gassiep <naz@mira.net>)
Responses Re: Changing DB Encodings  (Naz Gassiep <naz@mira.net>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Naz Gassiep
Date:
Subject: Re: Changing DB Encodings
Next
From: Naz Gassiep
Date:
Subject: Re: Changing DB Encodings