node-odbc icon indicating copy to clipboard operation
node-odbc copied to clipboard

[BUG] Losing decimal places

Open Relbot opened this issue 4 months ago • 12 comments

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

Relbot avatar Oct 26 '24 15:10 Relbot