pyodbc: Regression from 4.0.35 to 4.0.39 - fetch fails for decimal fields when system locale decimal separator is not '.'

  • Python: 3.11, 32 Bit
  • pyodbc: 4.0.39
  • OS: windows
  • DB: navision c-side
  • driver: Navision CODBC

Issue

regression from pyodbc: 4.0.35 to 4.0.39

on 4.0.39 fetching a row from a table fails, if the field type is decimal on 4.0.35 it works just fine

Pseudocode:

    cursor.execute("select testfield_ from testtable where Nr = ?", ['42'])
    cursor.fetchone()
    Traceback (most recent call last):
    TypeError: sub() missing 1 required positional argument: 'string'

About this issue

  • Original URL
  • State: closed
  • Created a year ago
  • Comments: 15 (2 by maintainers)

Most upvoted comments

@gordthompson , thanks again, I updated my proposal for future handling. i hope it can be useful. Thank You very much and greetings from Vienna, Austria Robert Nowotny, aka bitranox