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
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Paradox v5.2
  HXTT Text(CSV) v5.2
  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)

HXTT Excel
Driver is converting characters in column headers
Bob Stine
2008-01-24 08:34:47.0
We are using Excel_JDBC30.jar, and processing an excel spread sheet. One of the column headers includes the characters © (in hex, 0xC2 and 0xA9).

When we use JDBC to get the column headers for this table (via DatabaseMetaData.getColumns()), these two characters are converted to 'C'.

Is there any way to prevent this character conversion?

Thanks!
Re:Driver is converting characters in column headers
HXTT Support
2008-01-24 20:22:40.0
You have used FirstRowHasNames=true conneciton prpoerty at here? It seems that HXTT Excel is using C as default column name since your column is the 3rd column.
Re:Re:Driver is converting characters in column headers
Bob Stine
2008-01-25 05:01:28.0
Sorry, your answer does not explain the behavior I am seeing. First of all, the © characters are a substring of the header. Instead of "Foo ©", we are getting "Foo C". Second, in our problem spreadsheet, the column with the unusual characters is column "O", the 15th, not column "C", the 3rd.

The driver is translating the characters. In our system, we have some VB programs that are getting the correct column names from the spreadsheet. When our Java program tries to look into the spreadsheet for the column found by the VB program, it is coming up empty, because the Excel_JDBC30.jar driver is changing the column names.

The best solution for us would be a way to configure the JDBC driver so that it does not change the character values.
Re:Re:Re:Driver is converting characters in column headers
HXTT Support
2008-01-25 05:47:44.0
Please send us that xls sample. BTW, charSet connection property maybe can hen you.
Re:Re:Re:Re:Driver is converting characters in column headers
Bob Stine
2008-01-28 06:20:30.0
I am having difficulties replicating the problem, and I no longer trust my original diagnosis.

Please close this issue. If I can get a clean test case, I'll forward it to you in a new thread.

Search Key   Search by Last 50 Questions




Google
 

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