Oracle tables and ODBC field sizes..

I have noticed something odd..

When I create a table on Oracle for example: create table testx (x number(2,1),y number(1),xx number(19),z number(20))

If I got into my application using ODBC and open the table with:

SQLEXEC(h,'select * from testx')

Then look at the fields sizes as shown by the application I notice the sizes are funny..

x->N(4,1)
y->N(3)
xx->N(20)
z->N(20)

Has anybody seen this? Of course I can code around this in the application
but I'm afraid what will happen if someone every fixes this bug and would like to know the reason that the system thinks the field is 2 bytes bigger.

This happens with both the micorsoft odbc for oracle driver and the oracle odbc driver.

BR
Tim Received on Fri Sep 05 2003 - 03:45:27 CDT