Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access 7.1.252
  HXTT Cobol 5.0.251
  HXTT DBF 7.1.252
  HXTT Excel 6.1.255
  HXTT Json 1.0.223
  HXTT Paradox 7.1.251
  HXTT PDF 2.0.251
  HXTT Text(CSV) 7.1.251
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Word 1.1.251
  HXTT XML 4.0.252
Offshore Outsourcing
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
   
   
   
Heng Xing Tian Tai Lab of Xi'an City (abbr, HXTT)

HXTT Text(CSV)
Escape character differences
Martin Ross
2006-01-30 00:00:00
Using Jan 30th package.

select `#` from A works

but

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

Merci,

Martin
Re:Escape character differences
HXTT Support
2006-01-30 00:00:00
" 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
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

Cheers,

Martin
Re:Re:Re:Escape character differences
HXTT Support
2006-01-30 00:00:00
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
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
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
Martin
2006-01-30 00:00:00
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.

Thanks,

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

Search Key   Search by Last 50 Questions




Google
 

Email: webmaster@hxtt.com
Copyright © 2003-2019 Heng Xing Tian Tai Lab of Xi'an City. | All Rights Reserved. | Privacy | Legal | Sitemap