Re: templates, encoding - Mailing list pgsql-general

From Tom Lane
Subject Re: templates, encoding
Date
Msg-id 16730.1122646908@sss.pgh.pa.us
Whole thread Raw
In response to templates, encoding  (Zlatko Matić <zlatko.matic1@sb.t-com.hr>)
List pgsql-general
=?iso-8859-2?Q?Zlatko_Mati=E6?= <zlatko.matic1@sb.t-com.hr> writes:
> My template0 and template1 have SQL ASCII encoding, while I created a =
> database with UNICODE encoding.
> Could it cause some conflicts ? If so, how can I change templates =
> databases to be UNICODE as well ?

The real question is whether the database's locale setting is compatible
with Unicode (utf-8).  If not, you're going to see some problems with
comparing and sorting non-ASCII characters.

initdb is the only way to fix a bad choice of locale, unfortunately.

            regards, tom lane

pgsql-general by date:

Previous
From: Csaba Nagy
Date:
Subject: Re: [JDBC] Bad plan for queries with IN clause
Next
From: "Stefan Scherf"
Date:
Subject: tool for analysing the postgres log-file