Home
Client APIs and toolsYou can use the HCL OneDB™ implementation of client APIs to develop applications for HCL OneDB™ database servers.
OneDB .NET Core ProviderThe .NET Core Provider for OneDB® is used for developing .NET applications.
HCL OneDB™ .NET Core Provider Guide
Mapping data typesThese topics describe how data types are mapped between HCL OneDB™ databases and the .NET Core Framework.
Display format of FLOAT, DECIMAL, or MONEY data typesThe display format of the HCL OneDB™ FLOAT, DECIMAL, or MONEY data types is specified by the values of the DBMONEY or CLIENT_LOCALE environment variables.

Display format of FLOAT, DECIMAL, or MONEY data types

The display format of the HCL OneDB™ FLOAT, DECIMAL, or MONEY data types is specified by the values of the DBMONEY or CLIENT_LOCALE environment variables.

The DBMONEY environment variable takes precedence over the CLIENT_LOCALE environment variable. If you do not set DBMONEY, the locale setting (CLIENT_LOCALE) is used to format the value. By default, DBMONEY is set to a dollar sign and a period ($.), and CLIENT_LOCALE is set to US English (en_us.CP1252). For example, if you set DBMONEY=Pt, the separator becomes a comma (,). A decimal value of 169.0 will then be formatted with a comma: 169,0.

The HCL® OneDB .NET Core Provider determines display format using the following precedence:

Connection string
Environment
Registry (SetNet settings)

The values in the connection string override all other settings. For more information, see the HCL OneDB Guide to SQL: Reference.