0

I'm trying to create a view in sqlite that contains double quotes (I'm using the SQlite Manager Addon in Firefox). According to the escape rules (doubling double quotes) the following statement should work

CREATE VIEW "Name with ""quotes""" AS SELECT columnname FROM tablename

However it doesn't and gives me the following error message when I try to look at it.

Error Message when using the SQL command schown above

CL.
  • 173,858
  • 17
  • 217
  • 259
user3210625
  • 163
  • 3
  • 13

1 Answers1

0

This command is correct.

The poblem is caused by SQLite Manager, which does not apply the quoting rules correctly. Please report this bug.

CL.
  • 173,858
  • 17
  • 217
  • 259