Re: [gnome-db] Per-table meta-data with capital letters in the table name?

[Vivien Malerba <vmalerba gmail com>]

2009/6/29 Murray Cumming <murrayc murrayc com>

I should take the time to make a test case, but it looks like libgda 4.0
fails to get the meta-data for a specified table if the table name has
capital letters. I guess that this is a quoting (and escaping) problem
somewhere.

Yes, you need to surround any SQL identifier which is not case insensitive (or which has some spaces, etc in it) with double quotes. You can use gda_sql_identifier_needs_quotes().

The doc in http://library.gnome.org/devel/libgda/4.0/information_schema.html#information_schema:sql_identifiers
mentions the quotes usage in Libgda, but maybe I should add reminders in the functions's documentation for functions where this may be a problem.

Vivien