Thread: BUG #1106: Big5 String equal doesn't work

BUG #1106: Big5 String equal doesn't work

From
"PostgreSQL Bugs List"
Date:
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.