We have a large application in FoxPro 6.0 that uses both FoxPro DBC and MS SQL as the backend database.

We are looking to port the application to an Oracle 8i database. We've used several logical fields (datatype bin in MS SQL) in the application. When upsizing the database to Oracle the datatype is set to NUMBER(1) in Oracle.

Apparently, Logical/Bit datatype is not supported in Oracle.

Is there any other solution other than making global changes to the FoxPro application?