For either Oracle or PostgreSQL, to store fractional numbers as well as whole numbers in a number field, add the following registry entry:

 

NUMBERCONVERT=1

 

Enables fractional numbers to be included in a number field in an Oracle or PostgreSQL database.

 

Environments: Client, Windows

For Oracle:

Configuration Manager: CONNX Settings; Current Key = CONNX\ORACLE; Key Value/Value Name =  NumberConvert

Unix Registry Setting:  CONNX.ORACLE.NUMBERCONVERT

For PostgreSQL:

Configuration Manager: CONNX Settings; Current Key = CONNX\POSTGRESQL; Key Value/Value Name =  NumberConvert

Unix Registry Setting:  CONNX.POSTGRESQL.NUMBERCONVERT