The Artima Developer Community
Sponsored Link

Java Buzz Forum
How To Escape Column Names in HSQLDB RDBMS

0 replies on 1 page.

Welcome Guest
  Sign In

Go back to the topic listing  Back to Topic List Click to reply to this topic  Reply to this Topic Click to search messages in this forum  Search Forum Click for a threaded view of the topic  Threaded View   
Previous Topic   Next Topic
Flat View: This topic has 0 replies on 1 page
Angsuman Chakraborty

Posts: 19816
Nickname: angsuman
Registered: Dec, 2003

Angsuman Chakraborty is the CEO and Chief Architect at Taragana
How To Escape Column Names in HSQLDB RDBMS Posted: May 26, 2007 3:49 AM
Reply to this message Reply

This post originated from an RSS feed registered with Java Buzz by Angsuman Chakraborty.
Original Post: How To Escape Column Names in HSQLDB RDBMS
Feed Title: Simple Thoughts - Java and Web Technology Blog
Feed URL: http://tech.gaeatimes.com/index.php/feed/
Feed Description: News and views as a Software Architect and Entrepreneur on Java and Web Software.
Latest Java Buzz Posts
Latest Java Buzz Posts by Angsuman Chakraborty
Latest Posts From Simple Thoughts - Java and Web Technology Blog

Advertisement
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: How To Escape Column Names in HSQLDB RDBMS

Topic: Webiste changes and information flow Previous Topic   Next Topic Topic: WordPress Beats Blogger in Google Search & News

Sponsored Links



Google
  Web Artima.com   

Copyright © 1996-2019 Artima, Inc. All Rights Reserved. - Privacy Policy - Terms of Use