Michal Čihař a écrit:
On 16.04.2004 12:38 +0200, Alexander M. Turek wrote:
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 above changes are in cvs and seems to work fine where I tested.
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.
Is somewhere available some short overview of MySQL vs. ANSI SQL differences? We would probably need a checkbox for this on export page...
Michal, I don't know if you know about http://dev.mysql.com/doc/mysql/en/Compatibility.html Marc