Re: column name syntax

put the whole column name in double quotes.

You will have to do that in queries as well as the table definition.

 

Andy

 

---

From: hsqldb-user-bounces@xxxxxxxxxxxxxxxxxxxxx [mailto:hsqldb-user-bounces@xxxxxxxxxxxxxxxxxxxxx] On Behalf Of Saad_Khawaja@xxxxxxxxxxxxxxx
Sent: Wednesday, June 06, 2007 8:53 AM
To: hsqldb-user@xxxxxxxxxxxxxxxxxxxxx
Subject: [Hsqldb-user] column name syntax

Hi 

I have a legacy table which has a special character like 
'#' in the column name like ACCT#. I am using hsqldb for in-memory unit testing. 
Hsqldb does not allow me to have a special character like '#' in the column name 
in my create table statement.  Is there anyway to escape the special 
character so that I can have special characters in column names. 
I would really appreciate any help in this 
regard. 

Thanks a lot. 
Saad Khawaja.

====================================================================== Confidentiality Notice: The information contained in and transmitted with this communication is strictly confidential, is intended only for the use of the intended recipient, and is the property of Countrywide Financial Corporation or its affiliates and subsidiaries. If you are not the intended recipient, you are hereby notified that any use of the information contained in or transmitted with the communication or dissemination, distribution, or copying of this communication is strictly prohibited by law. If you have received this communication in error, please immediately return this communication to the sender and delete the original message and any copy of it in your possession. ======================================================================

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/_______________________________________________
Hsqldb-user mailing list
Hsqldb-user@xxxxxxxxxxxxxxxxxxxxx
https://lists.sourceforge.net/lists/listinfo/hsqldb-user