data_type for blob field [message #92416] |
Mon, 05 July 2004 22:48 |
Amrit
Messages: 10 Registered: December 2002
|
Junior Member |
|
|
Hi,
I'm developing an application in java, which connect to various databases depending upon driver/dsn provided at runtime.
Since blob cannot be inserted directly, i need to know the data_type of column, so that i can do some adjustment for inserting blob field. But when i try to get column data_type using getColumns(......) method of DatabaseMetaData, its giving me '1111' which is for 'Other' in java.sql.Types not the '2004'(blob) as expected.
Please let me know how can I know that particular column type is blob(or clob).
Thanks & regards,
Amrit
|
|
|