Hi All, Beta2 Guru Hints says:
### QUOTE BEGINS Unicode encoding on a Win32 server The database XXXXXX is created to use Unicode (UTF8) encoding to store data and is operated on a PostgreSQL 8.0 server running on a Win32 server. The PostgreSQL 8.0 Win32 implementation is not able to sort character strings according to appropriate collation sequences, because the operating system doesn't offer sufficient support for this. For this installation, it is recommended to use a locale specific encoding, run the cluster on a different operating system or upgrade your database cluster to PostgreSQL 8.1 which has additional code to deal with unicode collations to solve the issue. ### QUOTE ENDS It is definitely wrong in saying it's a Win32 server. It's a debian linux server. Just thought the info may be of use. dueyduey ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
