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.
|
>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.
|
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!
|
>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.
|
Main
webmaster@hxtt.com