Re: [SQL] problem comparing strings when different cluster / database encoding

2006-04-05 Thread Alvaro Herrera
Tomas Vondra wrote: Hi, > I've encountered a strange problem. We have a PG 8.0.x database cluster > (in the sense used in initdb, i.e. bunch of databases) created with > UNICODE encoding, namely cs_CZ.UTF-8 locale. > > When a database is created with a different encoding (in our case it's > LATI

Re: [SQL] problem comparing strings when different cluster / database encoding

2006-04-05 Thread Tom Lane
Tomas Vondra <[EMAIL PROTECTED]> writes: > I've encountered a strange problem. We have a PG 8.0.x database cluster > (in the sense used in initdb, i.e. bunch of databases) created with > UNICODE encoding, namely cs_CZ.UTF-8 locale. > When a database is created with a different encoding (in our cas

[SQL] problem comparing strings when different cluster / database encoding

2006-04-05 Thread Tomas Vondra
Greetings, I've encountered a strange problem. We have a PG 8.0.x database cluster (in the sense used in initdb, i.e. bunch of databases) created with UNICODE encoding, namely cs_CZ.UTF-8 locale. When a database is created with a different encoding (in our case it's LATIN2) the string comparison