The use of delimited identifiers are required to properly handle database object names that consists of special characters, whitespace, and/or mixed case names. When delimited identifiers are enabled, Informix follows the SQL-92 rules for the use of double quotation marks (”) around database identifiers and the single quotation mark (') in SQL statements.


To support the default behavior in Informix, delimited identifiers are not enabled automatically in DbVisualizer. To enable, open the connection Properties tab for your Informix connection, select Driver Properties and in the right pane add this parameter and value:


DELIMIDENT = Y


Click Apply and then connect the database connection.