From: | "PostgreSQL Bugs List" <pgsql-bugs(at)postgresql(dot)org> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #1106: Big5 String equal doesn't work |
Date: | 2004-03-18 05:29:21 |
Message-ID: | 20040318052921.784E4CF4D2C@www.postgresql.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 1106
Logged by: Jer-Min Tsai
Email address: tjm(at)fhl(dot)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(at)vexp(dot)idv(dot)tw','');
insert into main values
('','','1943/05/15','06-1234567','02-03213213','09181234567'
,'ban(at)gov(dot)tw','');
insert into main values
('','','1923/06/16','02-7654321','02-43210321','09601234567'
,'jan(at)kmt(dot)org(dot)tw','');
insert into main values
('','','1928/02/18','04-1234567','04-03213213','09601234567'
,'yui(at)green(dot)org(dot)tw','');
insert into main values
('','','1943/02/13','06-1234567','02-03213213','09181234567'
,'tjm(at)vexp(dot)idv(dot)tw','');
insert into main values
('','','1935/12/05','02-1234567','02-03213213','09184321231'
,'tjm(at)vexp(dot)idv(dot)tw','');
select * from main where gender='';
It can not show only gender=''.
I tried Like '' is ok. = ASCII String is ok.
From | Date | Subject | |
---|---|---|---|
Next Message | PostgreSQL Bugs List | 2004-03-18 14:38:28 | BUG #1107: Missing feature: interval <-> numeric quantity conversion |
Previous Message | PostgreSQL Bugs List | 2004-03-18 04:46:08 | BUG #1105: psotmaster error |