Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

ODBC real, float, double comma separator #98

Open
GooG2e opened this issue Apr 22, 2019 · 1 comment
Open

ODBC real, float, double comma separator #98

GooG2e opened this issue Apr 22, 2019 · 1 comment

Comments

@GooG2e
Copy link

GooG2e commented Apr 22, 2019

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
Copy link

mlt commented Aug 23, 2020

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 ?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

3 participants