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