Hi Gerry, Thanks for your reply.
When I rename a table, SQLite seems to override the quote characters I use, instead using single quote marks. Is this a bug?
The quote characters used in creating a table are not part of the table name.
Yes, I understand that they're not part of the name. But they do come into play for human recognition, and when parsing the SQL of say a trigger that contains a reference to a renamed table.
SQLite just uses apostrophes, aka single quotation marks, aka single quotes, when outputting the names.
But that seems to contradict SQLite's own documentation, which suggests square brackets of double quotes be used for user-defined objects (eg table names and column names).
This bug only seems to affect table names when renamed. If I create a new table or add a column, SQLite keeps in the resulting schema the quotes that I used to create it.
Thanks, Tom ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
