Wrong columnQuoteCharacter default in Schema for sqlite3
#20150
Comments
santilin
added a commit
to santilin/yii2-sqlite3-full-support
that referenced
this issue
Apr 28, 2024
Set default identifier quotes to " Fixed change and rename columns to allow any kind of quotes: ' " [ `
|
The proposal makes sense. Decided that it is not worth changing in Yii2, since it would be incompatible for already working code. But this can be changed in Yii3 https://github.com/yiisoft/db-sqlite |
|
I have tested it in Yii2 and the table quote character must be double quote or the queries will fail. This needs testing in Yii3. |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
The default quote char for columns in sqlite3 is double quote.
From the docs:
"keyword" A keyword in double-quotes is an identifier.
keywordA keyword enclosed in grave accents (ASCII code 96) is an identifier. This is not standard SQL. This quoting mechanism is used by MySQL and is included in SQLite for compatibility.Should it be changed?
In my extension yii2-sqlite3-full-support I have changed it to the correct value.
The text was updated successfully, but these errors were encountered: