=?iso-8859-2?Q?Zlatko_Mati=E6?= <zlatko.matic1@xxxxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster