I have used:
CREATE TABLE T1 (A DECIMAL(10,2));
after I have used the table and the A field have 2 decimal.
If I close the connection and reopen it the A is transformed in DOUBLE.
The same is for VARCHAR(n), if I close the connection and reopen it varchar(n) is trasformed in longvarchar;
But if I use
ResultSet rs = connection.getMetaData().getTypeInfo();
LONGVARCHAR not is in the list;
I can work with VARCHAR(N), DECIMAL(s,d), NUMERIC(s,d)?
You can add the longvarchar in typeInfo?
|
>CREATE TABLE T1 (A DECIMAL(10,2));
>after I have used the table and the A field have 2 decimal.
>If I close the connection and reopen it the A is transformed in DOUBLE.
You're using MS Access 95(97) format, which doesn't support decimal.
>The same is for VARCHAR(n), if I close the connection and reopen it varchar(n)
> is trasformed in longvarchar;
Tested and didn't find that issue. VARCHAR is varchar still.
|
Main
webmaster@hxtt.com