I'm a MS SQL Server user and I am used to the default case-insensitive
collation order. Is there a way to configure firebird to behave the same
way? I would like this to apply to indexes, constraints and be used for the
WHERE clause of a SQL statement.



To illustrate what I am looking for:



CREATE TABLE COLOR ("NAME" VARCHAR(50));

CREATE UNIQUE INDEX "UIX_NAME" ON "COLOR" ("NAME");

commit;

INSERT INTO COLOR ("NAME") VALUES ('Red');

INSERT INTO COLOR ("NAME") VALUES ('Blue');

INSERT INTO COLOR ("NAME") VALUES ('green');

commit;



INSERT INTO "COLOR" ("NAME") VALUES('Green'); -- I want this to fail
because of the index

SELECT COUNT(0) FROM COLOR WHERE "NAME" = 'GREEN'; -- I want this to return
1



Thanks for any help.



James





[Non-text portions of this message have been removed]