[Phpmyadmin-devel] RFE 859815 - ANSI compatible exports

[Marc Delisle]

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