The following bug has been logged online:
Bug reference: 1106
Logged by: Jer-Min Tsai
Email address: [EMAIL PROTECTED]
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'
,'[EMAIL PROTECTED]','台南市南區北門路');
insert into main values
('陳水扁','男','1943/05/15','06-1234567','02-03213213','09181234567'
,'[EMAIL PROTECTED]','台南縣官田鄉官田路');
insert into main values
('連戰','男','1923/06/16','02-7654321','02-43210321','09601234567'
,'[EMAIL PROTECTED]','台北市天母');
insert into main values
('宋楚瑜','男','1928/02/18','04-1234567','04-03213213','09601234567'
,'[EMAIL PROTECTED]','台北市總統路');
insert into main values
('吳淑珍','女','1943/02/13','06-1234567','02-03213213','09181234567'
,'[EMAIL PROTECTED]','台南縣官田鄉官田路');
insert into main values
('呂秀蓮','女','1935/12/05','02-1234567','02-03213213','09184321231'
,'[EMAIL PROTECTED]','桃園縣桃園市總統路');
select * from main where gender='男';
It can not show only gender='男'.
I tried Like '男' is ok. = ASCII String is ok.
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
