|Subject||RE: Re: [firebird-support] Firebird V3RC2 Primary Key question|
Would you be so kind to provide an example SQL which shows how to do primary key with a case insensitive collation?
This is the default and expected behavior. If you want case insensitive, then you need to create the primary key column with a case insensitive collation.
It’s been a while since I last used Firebird. I am testing new release candidate at the moment. Just found something I am not so sure.
I have a database created using “CharSet WIN1254” parameter.
Below is the SQL I used to create a table in that database:
CREATE TABLE KULLANICI
KODU VARCHAR(30) NOT NULL PRIMARY KEY,
And, all below executes without error:
INSERT INTO KULLANICI(KODU) VALUES(‘EK’);
INSERT INTO KULLANICI(KODU) VALUES(‘ek’);
INSERT INTO KULLANICI(KODU) VALUES(‘Ek’);
INSERT INTO KULLANICI(KODU) VALUES(‘eK’);
I can insert “EK”, “ek”, “Ek”, and “eK” as new records in the KODU column of that table. Somehow primary key of that table is case-sensitive.
I couldn’t find anything about primary key defaults to case-sensitive in the “Firebird-3.0.0_RC2-ReleaseNotes.pdf”. I don’t remember if that was the case in earlier versions, too. Just want to be sure about it. Can anybody confirm if that is a feature?
On my part, I would like to avoid it if possible.