Re: [phpodpworld-users] phpODPWorld sql file and quoting

[Hans F. N. <Han...@hi...>]

* Wayne Khan [2007-06-01]:
> Hi hansfn,
> I noticed that the tools/db.sql file has some syntax errors. Table names 
> should be enclosed in backticks, not double quotes!

phpODPWorld is written to work with both MySQL and PostgreSQL (and
other databases supported by Pear DB), so using backticks isn't
portable - it's MySQL specific (AFAIK and can read from the MySQL and
PostgreSQL docs). Double quotes works fine in MySQL if you are using 
ANSI_QUOTES SQL mode - ref http://www.mysql.org/doc/refman/5.1/en/identifiers.html 
(You are the first MySQL user complaining...)

An option would be to not use quotes at all, but since PostgreSQL 
folds un-quoted identifiers to lower case (which is incompatible with
the SQL standard) quoting is recommended when writing portable apps.

Regards,
Hans - who really isn't a DB expert.

PS! Please use the mailing list for such questions so other users can
benefit - I have forwarded this e-mail to the list.