We are trying to query a customer's remote FP2.6DOS database but we're having some character translation problems. Our applicaiton is written in Java, and we're using a JDBC/ODBC bridge to query the FP database. The JDBC driver resides on the customer's server.

The application which populates the database creates a hexadecimal value which is stores into a text field. When we do the joins within FoxPro everything works great. When we store the primary key for use in subsequent queries, the joins do not work.

The reason they don't work is the characters in the key fields don't match up with characters on our machines. It's like FoxPro is using an antiquated codepage for its character set, and when we store the value it takes its best guess as to what the characters are.

The same thing happens when I copy the FP2.6DOS database to my harddrive and link/import using MSAccess. As soon as those fields are outside of FP2.6DOS the character translations are corrupted.

Does anyone have any idea how we read a FP2.6DOS database and retain the key fields in their original character set so our subsequent queries work?

Greg
gvondembach@gartonworks.com