Jump to navigation Jump to search
no edit summary
== Notes ==
* Remove database name from SQL query: SQLite will consider the database name as table name
* In MySQL, string are able to quoted with single quote symbol {{kbd | key=<nowiki>'</nowiki>}} or double quote symbol{{kbd | key=<nowiki>"</nowiki>}}. In SQLite the string quoted with double quote symbol will be considered as '''column name'''! It will cause the problem: "no such column: xxx"
* Replace the following functions
** Replace MySQL [ CHAR_LENGTH] function with SQLite [,returns%20the%20number%20of%20bytes. Length] function<ref>[ sqlite does not have CHAR_LENGTH function · Issue #47 · owncloudarchive/mozilla_sync]</ref>

Navigation menu