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.

Rate this topic

5 stars 4 stars 3 stars 2 stars 1 star

Comment on this topic.

By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at https://hcltechsw.com/resources/us-government-contact. Do not include any personal data in this Comment box.