15 Apr
2004
15 Apr
'04
10:21 p.m.
Hi all
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?
- changing \' to '', this should be also work fine as default,
shouldn't?
https://sourceforge.net/tracker/?func=detail&atid=377411&aid=859815…
--
Regards
Michal Čihař
http://cihar.com
16 Apr
16 Apr
12:39 a.m.
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 :-)
--
Alexander M. Turek
<rabus(a)users.sourceforge.net>
_ __ __ _ _ _
_ __ | |__ _ __ | \/ |_ _ / \ __| |_ __ ___ (_)_ __
| '_ \| '_ \| '_ \| |\/| | | | | / _ \ / _` | '_ ` _ \| | '_ \
| |_) | | | | |_) | | | | |_| |/ ___ \ (_| | | | | | | | | | |
| .__/|_| |_| .__/|_| |_|\__, /_/ \_\__,_|_| |_| |_|_|_| |_|
|_| |_| |___/
<http://www.phpmyadmin.net>
2:32 a.m.
On 16.04.2004 12:38 +0200, Alexander M. Turek wrote:
Hi there,
Michal Cihar wrote:
The above changes are in cvs and seems to work fine where I tested.
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.
Is somewhere available some short overview of MySQL vs. ANSI SQL
differences? We would probably need a checkbox for this on export
page...
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.
Hmm, thats not nice, as we use SHOW CREATE TABLE for this ... that means
parsing of that output or generating whole statement :-(
I am not sure whether MySQL charset parameters are
ANSI compatible, but the collation tables are not.
We IMHO do not export these these things at all now.
Happy coding :-)
Thanks :-))
--
Regards
Michal Čihař
http://cihar.com
3:18 a.m.
Michal Čihař a écrit:
On 16.04.2004 12:38 +0200, Alexander M. Turek wrote:
Michal,
I don't know if you know about
http://dev.mysql.com/doc/mysql/en/Compatibility.html
Marc
Hi there,
Michal Cihar wrote:
The above changes are in cvs and seems to work fine where I tested.
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.
Is somewhere available some short overview of MySQL vs. ANSI SQL
differences? We would probably need a checkbox for this on export
page...
7449
days inactive
7449
days old
3 comments
3 participants
participants (3)
-
Alexander M. Turek -
Marc Delisle -
Michal Čihař