On Wednesday 26 January 2005 20:01, you wrote: > "Vladimir S. Petukhov" <vladimir@xxxxxxxxxx> writes: > > pg_controldata /var/pgsql/data > > ... > > LC_COLLATE: ru_RU > > LC_CTYPE: ru_RU > > > > bash-2.05b# psql -l > > List of databases > > Name | Owner | Encoding > > -----------+----------+---------- > > testdb | postgres | UNICODE > > > > And LIKE, ILIKE, ~ do not recognize upper/lower case.. > > What character encoding is implied by those LC_ settings on your machine? > If it's different from the database encoding (here utf8) these things > won't actually work right. LANG=ru_RU.koi8r LC_ALL=ru_RU.koi8r But how it act on lower/upper cases? Client use utf-8 encoding... > > Also, before PG 8.0 upper/lower simply don't work on multibyte characters, > which means you'd have to use a single-byte encoding to make it work > (I think koi8 is single-byte but not sure). > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your > message can get through to the mailing list cleanly -- You feel a whole lot more like you do now than you did when you used to. Now playing: AutoGenerated by fortune & xmms... ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster