node-odbc
node-odbc copied to clipboard
[BUG] Losing decimal places
Describe your system Running on Fedora Linux 38 (Workstation Edition) Kernal Version: Linux 6.2.9-300.fc38.x86_64
-
odbc
Package Version: ^2.4.9 - ODBC Driver: Zen-Client-linux-15.21-005.000.x86_64
- Database Name: Pervasive SQL (Actian Zen)
- Database Version: 15.21-005.000
- Node.js Version: 18.18.2
- Node.js OS:
Describe the bug When I query any database table where the rows contain decimal numbers I lose the decimal places Example: column X contains 3.5, when I query this column the result is only 3.
column result definition is
{
name: "vk_1",
dataType: 2,
dataTypeName: 'SQL_NUMERIC',
columnSize: 9,
decimalDigits: 2,
nullable: false
}
Expected behavior Result should be 3.5 instead of 3
If I do the same query with isql
I get the result 3.5
Best Regards Tell