hi all,

why a case-insensitive collate like ES_ES or EN_US works for SORT and not
for WHERE?
(on fb1.5rc4 ss windows/linux)

example:

CREATE TABLE TABLE1 (FIELD1 VARCHAR (100) CHARACTER SET ISO8859_1 COLLATE
ES_ES);

INSERT INTO TABLE1 (FIELD1) VALUES ('A1');
INSERT INTO TABLE1 (FIELD1) VALUES ('B1');
INSERT INTO TABLE1 (FIELD1) VALUES ('a2');
INSERT INTO TABLE1 (FIELD1) VALUES ('b2');

select * from table1 order by field1

field1
------
A1
a2
B1
b2

select * from table1 where field1 = 'a1'

(no records)

select * from table1 where field1 = 'a1' collate ES_ES

(no records)

can anybody explain me that?

thanks,
mariano podesta