RE: [Phpmyadmin-devel] RFE 859815 - ANSI compatible exports

Hi there,

Michal Cihar wrote:

I'd like to implement this one, but I'm not sure what all is needed.

• changing comment mark from # to --, this should not break anything so there is no need to make switch for this, am I right?

Sure.

• changing ' to '', this should be also work fine as default, shouldn't?

Haven't tested it, but it should work.

The problem is the table and field names: you cannot enclose them in backticks here, ANSI only allows doublequotes for this purpose. In MySQL, doublequotes may be used for strings only, so this would be a big incompatibility.

In addition to this, many table parameters that MySQL adds to the CREATE TABLE statement if they are needed are not ANSI compatible, like MyISAM options for example. Of course, it's the same thing with the table types.

I am not sure whether MySQL charset parameters are ANSI compatible, but the collation tables are not.

Happy coding :-)