BUG #1106: Big5 String equal doesn't work
От | PostgreSQL Bugs List |
---|---|
Тема | BUG #1106: Big5 String equal doesn't work |
Дата | |
Msg-id | 20040318052921.784E4CF4D2C@www.postgresql.com обсуждение исходный текст |
Список | pgsql-bugs |
The following bug has been logged online: Bug reference: 1106 Logged by: Jer-Min Tsai Email address: tjm@fhl.net PostgreSQL version: 7.4 Operating system: Linux Fedora Core 1 Description: Big5 String equal doesn't work Details: DataBase Version 7.4 ,7.2 DataBase Encoding EUC_TW client encoding Big5 SQL as below: create table main( name character(10), gender character(1), birthday timestamp, tel character(16), fax character(16), mobil character(16), email character(60), address character(100) ); insert into main values ('è¡å²æ°','ç·','1986/02/13','07-1234567','06-03213213','09311234567' ,'tjm@vexp.idv.tw','å°åå¸åååéè·¯'); insert into main values ('鳿°´æ','ç·','1943/05/15','06-1234567','02-03213213','09181234567' ,'ban@gov.tw','å°å縣å®ç°éå®ç°è·¯'); insert into main values ('飿°','ç·','1923/06/16','02-7654321','02-43210321','09601234567' ,'jan@kmt.org.tw','å°åå¸å¤©æ¯'); insert into main values ('宿¥ç','ç·','1928/02/18','04-1234567','04-03213213','09601234567' ,'yui@green.org.tw','å°åå¸ç¸½çµ±è·¯'); insert into main values ('峿·ç','女','1943/02/13','06-1234567','02-03213213','09181234567' ,'tjm@vexp.idv.tw','å°å縣å®ç°éå®ç°è·¯'); insert into main values ('åç§è®','女','1935/12/05','02-1234567','02-03213213','09184321231' ,'tjm@vexp.idv.tw','æ¡å縣æ¡åå¸ç¸½çµ±è·¯'); select * from main where gender='ç·'; It can not show only gender='ç·'. I tried Like 'ç·' is ok. = ASCII String is ok.
В списке pgsql-bugs по дате отправления: