Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v5.2
  HXTT Cobol v2.1
  HXTT DBF v5.2
  HXTT Excel v4.2
  HXTT Paradox v5.2
  HXTT Text(CSV) v5.2
  Buy Now
  HXTT XML v1.2
Offshore Outsourcing
Oracle Data Import/Export
DB2 Data Import/Export
Sybase Data Import/Export
Free Resources
  Firewall Tunneling
  Search Indexing Robot
  Conditional Compilation
  Password Recovery for MS Access
  Password Recovery for Corel Paradox
  Checksum Tool for MD5
  Character Set Converter
  Pyramid - Poker of ZYH
Hongxin Technology & Trade Ltd. of Xiangtan City (abbr, HXTT)

Escape character differences
Martin Ross
2006-01-30 00:00:00.0
Using Jan 30th package.

select `#` from A works


select o.`#` from A o generates a lexical error. This is not correct behaviour IMHO.


Re:Escape character differences
HXTT Support
2006-01-30 00:00:00.0
" is used to quote SQL identifiers. ' is for string constant.

"select '#' from A" means '#' as a constant value in select-list.
"select "#" from A" means "#" is a special column name in table a.
"select o."#" from o" means is supported but your table hasn't such a "#" column so that you will get "Invalid column: o.#" exception.
"select o.'#' from A o" can't be understood.
Re:Re:Escape character differences
Martin Ross
2006-01-30 00:00:00.0
To clarify
` is a backtick, not a single quote. I am wrapping with a backtick (a common escape character)...

If ` is not an escape character then it should be ;p


Re:Re:Re:Escape character differences
HXTT Support
2006-01-30 00:00:00.0
Both of "select `#` from A" and "select o.`#` from A o" won't work. ` is not an escape character.
Re:Re:Re:Re:Escape character differences
HXTT Support
2006-01-30 00:00:00.0
You can use any character in string value, except for '. For instance, 'Tom's dog' should be 'Toms''s dog'. That's all.
Re:Re:Re:Re:Re:Escape character differences
HXTT Support
2006-01-30 00:00:00.0
If you used "Statment.setEscapeProcessing(true)", and have a sql with "select\t\b'\\\x33\u0056' from a\r\n" in a file. Then HXTT DBF will convert it and begin syntax analysis. If you wish to test such a fuction, you have to use "select\\\t\\\b'\\\\\\\x33\\\u0056' from a\\\r\\\n" in your Java code, otherwise Java compiler will consume all \.
Re:Re:Re:Re:Re:Re:Escape character differences
2006-01-30 00:00:00.0
This is actually just an issue with Hibernate since if one uses the MySQL dialect is attempts to escape using the backtick character. It would be beneficial for your company to contribute a dialect fully supporting HXTT series drivers for the next hibernate release.


Re:Re:Re:Re:Re:Re:Re:Escape character differences
HXTT Support
2006-05-10 21:56:44.0
The latest Hibernate support package is at here.

Search Key   Search by Last 50 Questions


Address: 9 Station Rd., Xiangtan City, Hunan Province, P.R. China
Postcode: 411100
Phone: (86)731-58225727
Fax: (86)731-58225727
Copyright © 1999-2011 Hongxin Technology & Trade Ltd. | All Rights Reserved. | Privacy | Legal | Sitemap