Get the real type of columns from MS Access databases(OLEObject, text, memo, numeric)  
Author Message
pocal7





PostPosted: 2003-12-23 16:35:00 Top

java-programmer, Get the real type of columns from MS Access databases(OLEObject, text, memo, numeric) Hello,

I made one application that opens MS Access databases.And I have one
problem.How can I find the real data type of columns(text, memo,
OLEObject, numeric) like it is into Access.I tried with
resultSetMetaData.getColumnType(columnIndex) but I receive
java.sql.Types.I have two columns that contains OLEObjects(images).But
I receive two different types for columns : VARCHAR once, and for
second column SMALLINT.I only want to see the types like in
Access(OLEObjects, Text, Numeric, Memo...).Thanks in advance!

Best regards,
Calin Pop