Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access 7.1.142
  HXTT Cobol 5.0.142
  HXTT DBF 7.1.143
  HXTT Excel 6.1.146
  Buy Now
  HXTT Json 1.0.114
  HXTT Paradox 7.1.142
  HXTT PDF 2.0.142
  HXTT Text(CSV) 7.1.142
  HXTT Word 1.1.142
  HXTT XML 4.0.143
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 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?

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


Copyright © 2003-2019 Heng Xing Tian Tai Lab of Xi'an City. | All Rights Reserved. | Privacy | Legal | Sitemap