Send the client locale

When the client application requests a connection, it sends the environment variables from the client locale to the database server.

The following environment variables are sent from the client locale to the database server:
  • Locale information
    • CLIENT_LOCALE

      If CLIENT_LOCALE is not set, the client sets it to the default locale.

    • DB_LOCALE

      If DB_LOCALE is not set, the client does not send a DB_LOCALE value to the database server.

  • User-customized display formats
    • Date and time display formats: GL_DATE and GL_DATETIME
    • Monetary display formats: DBMONEY

    If you do not set any of these environment variables, the client application does not send them to the database server, and the database server uses the display formats that the CLIENT_LOCALE defines.

The database server uses these settings to extract the following information:
  • How are numeric and monetary values formatted?
  • How are dates and times formatted?
  • What database locale does the client expect?

The database server uses this information to verify the database locale and to establish the server-processing locale.