[Typo3-dev] MySQL and column-name quoting...

[Michael Stucki]

Jochen Weiland wrote:

> Looks like we are getting into a general problem here with mysql
> versions. One idea would be to add the identifier in general - but that
> causes incompatibility with mysql before version 4.1. From the mysql
> manual:
> 
> "Before MySQL 4.1, identifier quote characters should not be used in
> identifiers."
> 
> When trying to import a sql file with identifiers into mysql <4.1 you
> get an error message, that there are no create table commands in the
> file - but they are there...
> 
> So actually we might need two versions of sql files, one with and one
> without identifier quotes. It really becomes messy, when both ways are
> mixed, like in the last update of the direct_mail extension.

No, we just need to patch the code which parses the SQL files.

See http://bugs.typo3.org/view.php?id=1155, though I didn't look deep enough
at it yet...

- michael
-- 
Use a newsreader! Check out
http://typo3.org/community/mailing-lists/use-a-news-reader/