Unanswered: Decimal symbol is "," (comma) instead of "." (DB2 Connect problem)
SW : DB2 Connect version 7 FixPack 12
After upgrading to the above version I started having this problem (only on one of our servers - others works fine) -
When I select data from a decimal number the decimal symbol is "," instead of "."
I have checked that global settings is US and that decimal symbol is set to "."
Can someone point me to where DB2 Connect reads what the decimal point is set to - or give a hint to where this can be changed. There is nothing in the db2cli.ini file that indicates that the decimal point should be ","
Thank you for your feedback, which helped me to solve the problem.
I'm using Windows 2000 and there are two settings for the regional options, one for the current user and one for system. Both of them were set to German (Switzerland). This locale defines '.' as the decimal symbol but I've still got ',' in my db results, so this seems to be a bug. After having changed the system locale to English (United States) I now get '.' again as desired.