Yeah, I am well aware off it. And it seems like MySQL since version 3.23 supports it. However, the small catch 22 that I was overlooking while cross-reading the manual was that you have to issue the following command to make MySQL recognize double-quotes:
SET sql_mode='ANSI_QUOTES'; Sources: http://dev.mysql.com/doc/refman/4.1/en/identifiers.html http://dev.mysql.com/doc/refman/5.0/en/identifiers.html So I guess that for the mysql specific case we could just issue that command. However, are there any other databases which do not support ansi-sql quotes at all? I know that MS-SQL allows you to use either double-quotes or square brackets, but since Wt generates the SQL already this would not be an issue for that backend. /Thomas 2010/3/22 omer katz <[email protected]>: > Thomas, You have to remember that we should support older mysql backends > aswell. > Who knows what stack you'll have to deal with? > > 2010/3/22 Thomas Dähling <[email protected]> >> >> 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 > > ------------------------------------------------------------------------------ > 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
