It's a Debian GNU/Linux, with a self-compiled 8.1.3 postgresql. Raph
On 4/14/06, Martijn van Oosterhout <kleptog@svana.org> wrote: > On Fri, Apr 14, 2006 at 03:16:01PM +0200, Raphael Bauduin wrote: > > Hi, > > > > Does the ilike operator work fine with cyrillic text put in a UTF-8 > > encoded database? > > I've had remarks of a user (of http://myowndb.com, a web database) > > with text in cyrillic that his searches are not case insensitive, > > although I use the ilke operator in the code. And it works perfectly > > for my data (that are not in cyrillic). > > UTF-8 support for case-comparison is operatnig system dependant. What > systems are we comparing here? > > Have a nice day, > -- > Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/ > > Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a > > tool for doing 5% of the work and then sitting around waiting for someone > > else to do the other 95% so you can sue them. > > > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.1 (GNU/Linux) > > iD8DBQFEP6gDIB7bNG8LQkwRAgyUAJsGusLIxrdkiaDg11727770bquYCgCfWgCZ > /SYTVp84hAf/jx8pO+js8pY= > =afee > -----END PGP SIGNATURE----- > > > ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
