Visual Foxpro client program with MySql database

[Josep Maria]

Hello, we are upsizing an application that we have made in Visual FoxPro so that the program works with a MySql database instead of a FoxPro database that we used until now.

We use ODBC to access the data. As MySql not supports the logical data type, we use for fields of
this type the type TINYINT of MySql that is an integer of 1 bytes to which we give a value of 0 or 1 according the concept we want represent, .T. or. F.

When executing from FOXPRO, a SQLEXEC via ODBC against a MySql table that has fields TINYINT,
it returns in the cursor of FOX integer field and not logical.

Somebody has implemented in some occasion some mechanism, or knows the how converting those integer fields that come in the cursor in logical FoxPro fields ?

We need in our application obtain logical fields and not integer fields because we would rewrite a lot of code.

Some driver exists ODBC of MySql that converts automatically the fields TINYINT of MySql in fields
logical. T. i. F. in FoxPro?

Has somebody met with this problem before? As him has it solved?

Sorry by my english.

Thank you.