Forum Discussion

AGo's avatar
AGo
Post Patron
4 years ago
Solved

Regional setting for decimal in Odbc.DataSource

Hello, I'm using Odbc.DataSource() to query a PostgreSQL database, every decimal field is returned without decimal (as an integer), it's easy form me to apply a division by 100, but now I'm querying...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-yingjl's avatar
    v-yingjl
    4 years ago

    Hi AGo ,

    Could not reproduce it in my side as far as my test. 

    Test Environment: 

    PostgreSQL 13 Database; ODBC Driver: postgresql_13_002.zip

     

    You can try to set the data type as numeric in PostgreSQL which is equal to decimal, refer: 8.1. Numeric Types 

     

    Best Regards,
    Community Support Team _ Yingjie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yingjl's avatar
v-yingjl
Community Support
4 years ago

Hi AGo ,

Could not reproduce it in my side as far as my test. 

Test Environment: 

PostgreSQL 13 Database; ODBC Driver: postgresql_13_002.zip

 

You can try to set the data type as numeric in PostgreSQL which is equal to decimal, refer: 8.1. Numeric Types 

 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.