Server versus Client Locale Settings

Vertica differentiates database server locale settings from client application locale settings:

The following sections describe best practices to ensure predictable results.

Server Locale

The server session locale should be set as described in Specify the Default Locale for the Database. If locales vary across different sessions, set the server locale at the start of each session from your client.

vsql Client

ODBC Clients

JDBC and ADO.NET Clients