~*, case insensitiveness and national chars
От | Marcin Owsiany |
---|---|
Тема | ~*, case insensitiveness and national chars |
Дата | |
Msg-id | 20030313232831.GA9922@melina.ds14.agh.edu.pl обсуждение исходный текст |
Ответы |
Re: ~*, case insensitiveness and national chars
|
Список | pgsql-general |
Hi, Consider the following commands: ] create database a encoding='LATIN2'; ] \connect a ] create table a (a character(1)); ] insert into a values(chr(161)); ] insert into a values(chr(177)); ] select count(a) from a where a ~* chr(161); On PostgreSQL 7.3.2 this returns 2 (which is correct, since chr(161) and chr(177) are the same character in LATIN2, just different case), but on postgresql 7.2.2, this returns 1. This suggests that the behavior of 7.2.2 is a bug, and something was fixed between those two versions. Could someone point me at relevant source file so that I can correct this in 7.2.2 (since unfortunately I can't just upgrade to 7.3.2 now). regards, Marcin -- Marcin Owsiany <marcin@owsiany.pl> http://marcin.owsiany.pl/ GnuPG: 1024D/60F41216 FE67 DA2D 0ACA FC5E 3F75 D6F6 3A0D 8AA0 60F4 1216 "Every program in development at MIT expands until it can read mail." -- Unknown
В списке pgsql-general по дате отправления: