If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
ODBC Text driver - Float datatype precision ??
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. |
Thread Tools | |
Display Modes | |
|
|