|Subject||Re: [firebird-support] Firebird V3RC2 Primary Ke y question|
Van: "Ertan Küçükoğlu ertan.kucukoglu@... [firebird-support]" <firstname.lastname@example.org>
Onderwerp: [firebird-support] Firebird V3RC2 Primary Key question
Datum: do, apr. 7, 2016 19:46
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.