Date: 05/26/07 (Java Web)    Keywords: database, sql

Sometimes you need to have database column names with space or other non-standard characters. The standard procedure is to escape them with backtick (`) character. HSQLDB doesn’t accept either backtick or single quote as escape character. Instead you have to use escaped double quotes as shown in the example below: st.execute("CREATE TABLE sheet (tg_meta_id int identity [...]

Source: http://blog.taragana.com/index.php/archive/how-to-escape-column-names-in-hsqldb-rdbms/