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
 
  Buy Now
  Support
  Download
  Document
  FAQ
  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 Paradox
Charset Encoding List
Father Peter
2010-07-15 17:03:39.0
I think I may have a charSet encoding problem. Your FAQ says you have an encoding list someplace, but I can't find it. Would you please either point me to where I can access this, or send it to me by email?

My problem has to do with the following characters:

��
��
��
��

I had originally converted data for an existing application we are rewriting in Java by taking it from Paradox to MySql to H2. These characters showed up fine in the Java application.

Today, I reconverted the same data directly from Paradox to H2, and those characters no longer show up properly in the Java application.

If this is not an encoding problem, do you have any ideas what I need to do to fix this?

Also, what is the proper way to escape single and double quotes using your driver?

Finally, in an unrelated question, your documentation says that the ParadoxJDBC4.0.jar contains the driver and a database GUI manager. How do we access that GUI manager?

I'd really appreciate any help you can give me with these questions.
Re:Charset Encoding List
HXTT Support
2010-07-15 17:21:42.0
>Also, what is the proper way to escape single and double quotes using your driver?
For instance, select '"aaa"','aaa''bbb'; //no special requirement for ", two '' means a '.

>Finally, in an unrelated question, your documentation says that the
>ParadoxJDBC4.0.jar contains the driver and a database GUI manager.
>How do we access that GUI manager?
java com.hxtt.sql.admin.Admin at here

>I had originally converted data for an existing application we are rewriting in
>Java by taking it from Paradox to MySql to H2. These characters showed up fine
>in the Java application.
>Today, I reconverted the same data directly from Paradox to H2, and those
> characters no longer show up properly in the Java application.
I guess that it should be an encloding issue for H2, because you can see normal uniocde string in Java application.

>Your FAQ says you have an encoding list someplace, but I can't find it.
http://download.oracle.com/docs/cd/E17476_01/javase/1.5.0/docs/guide/intl/encoding.doc.html . It supports all of JVM's supported unicode, locales and encodings. Cp895(Czech MS - DOS 895), Cp620(Polish MS - DOS 620) and Mazovia are extra supported although JVM doesn't support those.

Re:Re:Charset Encoding List
Father Peter
2010-07-16 09:33:29.0
You may be right. This may not be a problem with your driver.

The data was not showing up correctly in the Paradox table using either SQuirrel-Sql ( http://squirrel-sql.sourceforge.net/ ) or our program.

I was going to say for you to create a Paradox table, put those characters in it, and you could see for yourself they did not look right; but I tried that myself first, and it worked!

The problem appears to be in my pre-conversion routine. With our Lord's help, I should be able to work around this problem.

I greatly appreciate you help. You have given excellent service, and it is appreciated.

Have a nice weekend!
Re:Re:Re:Charset Encoding List
HXTT Support
2010-07-16 17:10:08.0
>The problem appears to be in my pre-conversion routine.
Maybe.

>The data was not showing up correctly in the Paradox table using either
>SQuirrel-Sql ( http://squirrel-sql.sourceforge.net/ ) or our program.
You can try jdbc:paradox:yourjdbcurl?charSet=onePossibleCharset, maybe your data will show up correctly if you choose a correct charSet, since HXTT Paradox supports many charSets.

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