I haven't used MySQL since a few years now, but after just having checked the documentation for mysql 5.0 it should actually support double-quotes for quoting identifiers.
Mobi: Could it be that it is just the mysql c api which does not support it? Are you using an earlier version of mysql which does not support double-quotes for identifiers? /Thomas 2010/3/22 Koen Deforche <[email protected]>: > Hey Thomas, Mobi, > > 2010/3/20 Thomas Dähling <[email protected]>: >> Agreed. It's just a personal thing here that I hate it when I have to >> create exceptions in my software because 3rd party software x or y >> does not fully comply with a standard. So we should not let this get >> in the way and take my previous statement with a grain of salt instead >> ;-) >> >> OK, so in order to solve this in a more practical approach my first >> idea was something like this: >> virtual const char delimiter() const { return '"'; } > > That would be indeed a solution. > > Btw. The first release of Wt::Dbo did not put delimiters, but, it > turns out that it is quite easy to come up with a table or column name > that is in fact an SQL keyword. That is the reason to put delimiters > everywhere... I also figured if SQLite supports it, so will the bigger > database engines ? > > Does MySQL not support it anywhere or only not in particular statements ? > > Regards, > koen > > ------------------------------------------------------------------------------ > Download Intel® Parallel Studio Eval > Try the new software tools for yourself. Speed compiling, find bugs > proactively, and fine-tune applications for parallel performance. > See why Intel Parallel Studio got high marks during beta. > http://p.sf.net/sfu/intel-sw-dev > _______________________________________________ > witty-interest mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/witty-interest > ------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ witty-interest mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/witty-interest
