Suggestion/wish.
One of the aspects of using H2 that can slow you down is that you
might need both single quotes and double quotes in the same SQL
statement which is problematic if you are using one of those to
delimit the entire statement since you get into using backslash
escapes (I am using R where strings are delimited by single quotes or
double quotes so must use escaping if both are in string.)
"select dateadd('day', 1, \"myDate\") from \"myTable\""
If back ticks were regarded to be the same as double quotes that would
make it a bit easier to work with and I suspect that is easy to
implement.
"select dateadd('day', 1, `myDate`) from `myTable`"
The best of course would be to allow case sensitivity as well but I
gather that that is harder to implement.
On Jan 16, 3:12 am, David Brown <[email protected]> wrote:
> On Fri, Jan 15, 2010 at 06:37:09PM -0800, ggrothendieck wrote:
> >- character strings must be single quoted and not double quoted.
> >- names that are not to be automatically upper cased are to be double
> >quoted and not other sorts of quotes.
>
> These are defined by the SQL standard. They are also explained in the
> grammar <http://www.h2database.com/html/grammar.html>
>
> >- back quotes do not preserve case
>
> I can't actually find a reference to backquotes in the documentation.
>
> >3. A case sensitive mode would be nice (wish list). Also would it be
> >feasible to use single or double quotes interchangeably rather than
> >have each only work for certain situations?
>
> It seems to actually be forbidden by the ANSI SQL standard, however.
>
> David
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
