vendredi 25 septembre 2015

sqlite quoted column name still case non sensitive (feature or bug)

I all, I discovered this

create table yo ([I] integer, [i] integer)
SQL error 1 : duplicate column name: i

Is this a feature or a bug? I red in the doc that we can quote column name.

I am writing code that is not DB portable (Using SQLITE_ name space everywhere) so is there a non-standard DB option setup that can make sqlite engine case sensitive.

I know purist will say that having 2 cols with the same name is non sensical, but I have situation where case in column names are derived from languages where case sensitivity makes sense.

Cheers, Phi

Aucun commentaire:

Enregistrer un commentaire