ODBC Text driver - Float datatype precision ??

[SubbaK]

Hi I am using Microsoft ODBC Text driver to read data from CSV files.

My csv file has numeric data with precision 20& scale 9. I am not able to
read this using text driver, there is a precision loss.

I am using float datatype, is it possible to use another datatype for this
precision? Or is it possible to configure float datatype to hold such large
values.

I need to do aggregate functions on the column so reading it as string
maynot be useful.

I am using JDBC-ODBC bridge to make my java application interact with the
ODBC text driver.

Any help on this would be highly appreciated.

Thanks.