search

CartoDB / odbc_fdw

PostgreSQL Foreign-data Wrapper for ODBC
Other
70 stars 22 forks source link

ODBC real, float, double comma separator #98

Open GooG2e opened 5 years ago

GooG2e commented 5 years ago

Context

I am trying to connect to DB2 database with this ODBC driver When I am trying to import tables with real, float, double types I have errors such as cannot convert to real (1,00000E). All problems comes from comma. How can I change this?

Steps to Reproduce

Please break down here below all the needed steps to reproduce the issue

  1. Import foreign table with float, real, double type
  2. Select from table gives error

Current Result

Error type conversion - real in postgresql can't convert with comma separator

Expected result

Receive values without commas or convert them

System trying to connect to and version

PostgreSQL 11, DB2 10.5

mlt commented 4 years ago

I never used DB2, however ODBC FDW takes data as text strings and I had my share of pain with that. Perhaps, your best bet is to request DB2 driver to use dot... so maybe https://stackoverflow.com/a/30118345/673826 ?