Has anyone ever seen this? IN VFP 6.0, ODBC Driver

I build a table on Oracle for example.

CREATE TABLE TEST (
col1 number(1) NOT NULL,
col2 number(2) NOT NULL,
col3 number(3) NULL)

Then in VFP do:
h=SQLCONNECT()
SQLEXEC(h,'select * from test','temp')
select temp
afields(a)
create table test from array a;
use test
modi stru

**Now note it has converted the types up by 2.
Numeric 3,
Numeric 4,
Numeric 5

This is causing me some problem.

I used both the Microsoft ODBC driver and Oracles 8's driver
with the same results.

The same thing happens with the AFIELDS()
function on the array.

Anyone know what is happening???

I also noticed if I use SQLCOLUMNS() 'NATIVE'
The precision column returns the correct answer.
But The Length does not...

The help says:

Precision = Precision of the column
Length = Transfer size of the data


Can anyone please explain this???