How To Escape Column Names in HSQLDB RDBMS

How To Escape Column Names in HSQLDB RDBMS

Note: This article will be emailed to your friend.

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 [...]

Read the rest of this article (103 words)

Please fill in the following fields

* - Required

Your Name: *

Your E-Mail: *

Your Remarks:

Friend's Name: *

Friend's E-Mail: *

Protected by Comment Guard Pro