trimming of tablenames

Hello, i'm generating tables in my application. The tablename comes from strings which can contain trailing blanks e.g. "TABLE_1 ". Some db-systems do a trim to the table-name by default, like db2, others don't like HSQL. I'm using HSQL and have tables, which contain spaces at the end. When it comes to displaying table data, dbvis reports an table-name not found error, because the tablename was trimmed. steps to reproduce (with HSQL) 1. create a table with the following statement CREATE TABLE "NAME WITH Blanks " ( id INTEGER ) 2. try to browse the table-data Is there a setting, where i can configure this behaviour? Other tools like SQL-Explorer (Eclipse Plugin) show me the table-data with no errors. regards Andreas Schmidt

Hello Roger, i already told dbvisualizer to quote the names. But as you mentioned this won't work for names with leading/trailing blanks. The reason for using such names is, that i develop a simulating jdbcdriver proxy. It writes out all resultsets from selectstatements into tables together with the parameters used for retrieving when it is in write-mode. The tables will be created dynamic with the original statement as name. I could also name the created table with a sort of hash-value generated from the statement. But a value from a hashfunction is ambigous and the original statement is unambigous. When the proxy it is in read-mode it could be used to emulate the original database during write mode. This proxy is meant for debugging and testing. The application i tested uses selects with trailing blanks, so my table-names had trailing blanks too. As a workaround I removed trailing blanks and it worked. But it would be nice, if there would be an option for switching off trimming of table-names. This could be on the same place where you specify the prefix/suffix. regards Andreas