tomc7777777 [08-12-27 21.41] :

> Phillipe, apologies for my ignorance but what does this mean for
> existing an FB1.5 to FB2.1 db?

Here some example with ISO8859_1 and Fb2.1

CREATE TABLE TEST1
(
VC Char(20) CHARACTER SET ISO8859_1 COLLATE FR_FR_CI_AI
);

INSERT INTO test1 (VC) VALUES ('azer');
INSERT INTO test1 (VC) VALUES ('aZer');

CREATE INDEX I1 ON TEST1 (VC);

SELECT VC FROM TEST1 WHERE VC ='azer';
1 azer
2 aZer
PLAN (TEST1 INDEX (I1))

SELECT VC FROM TEST1 WHERE VC COLLATE FR_FR ='azer' ;
1 azer
PLAN (TEST1 NATURAL)

CREATE INDEX I2 ON TEST1 COMPUTED BY (VC COLLATE FR_FR);
SELECT VC FROM TEST1 WHERE VC COLLATE FR_FR ='azer' ;
1 azer
PLAN (TEST1 INDEX (I2))