=?iso-8859-2?Q?Zlatko_Mati=E6?= <zlatko(dot)matic1(at)sb(dot)t-com(dot)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