Support Center > Knowledgebase > phpMyAdmin > Known Limitations > I get error messages when using "--sql_mode=ANSI" for the MySQL server
I get error messages when using "--sql_mode=ANSI" for the MySQL server
When MySQL is running in ANSI-compatibility mode, there are some major differences in how SQL is structured (see http://dev.mysql.com/doc/mysql/en/ANSI_mode.html). Most important of all, the quote-character (") is interpreted as an identifier quote character and not as a string quote character, which makes many internal phpMyAdmin operations into invalid SQL statements. There is no workaround to this behaviour. News to this item will be posted in bug:816858
Also Read