Would you be so kind to provide an example SQL which shows how to do primary key with a case insensitive collation?
Thanks. Ertan From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: Thursday, April 7, 2016 8:54 PM To: firebird-support@yahoogroups.com Subject: Re: [firebird-support] Firebird V3RC2 Primary Key question 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. Mark ----- Bericht beantwoorden ----- Van: "Ertan Küçükoğlu ertan.kucuko...@1nar.com.tr <mailto:ertan.kucuko...@1nar.com.tr> [firebird-support]" <firebird-support@yahoogroups.com <mailto:firebird-support@yahoogroups.com> > Aan: <firebird-support@yahoogroups.com <mailto:firebird-support@yahoogroups.com> > Onderwerp: [firebird-support] Firebird V3RC2 Primary Key question Datum: do, apr. 7, 2016 19:46 Hi, 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, ADI VARCHAR(50), SIFRE VARCHAR(64), EMAIL VARCHAR(60), ); 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. Thanks. Regards, Ertan Küçükoğlu
