I know that SapDB/MaxDB databases supports mixed case quoted identifiers, so all identifiers in my application are specified between quotes and mixed case is used for their naming. Everything works fine, until a query for a table descriptions is made invoking getTables() from the meta data, using the same rule, every identifiers between quotes. It seems that in this case the quotes are not needed anymore, because specifying here a quoted identifier for the tableNamePattern parameter will make sure that the table definition is not found even if it exists. Is this a correct behavior? i guess it's not, please correct me if i'm wrong. How should my application know, when to use quoted identifiers and when should't?
Quoting is _only_ important, when embedding something into a SQL-Statement. There are two way of Quoting:
- Quoting an Identifier (a table name)
- Quoting a Value (a string, integer, ...)
The type of quoting you need must be decided on where you put the string you want to quote.
SELECT * FROM "MyTable" SELECT * FROM table WHERE name='MyTable'
As you can see, we have two different types of Quoting, one with " for the identifiers, and one with ' for the values.
And of course if you ask SAPDB for the existing tables, it will not return a quoted name, since quoting is only necessary when embedding something into an SQL-Statement.
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
