SQL Internationalization and Localization

All character strings in the NuoDB database are stored in UTF-8 format. Your client application must take care of conversion to and from UTF-8 of input data and output data.

You can handle this in the client application by setting the LANG and LC_ALL environment variables to the encoding you are using. Note that these settings are required to interact with nuosql, or any other command line client by means of stdin and stdout, as well as for a client reading from a file that has a non-default encoding.

On Windows, you may also be required to use the CHCP command.

All C++ clients must call setlocale() with an empty string to initialize the client with information about the current locale settings. For example:

setlocale(LC_ALL, "");

Sometimes, locale settings are inherited from the server environment and client side settings are ignored. When this occurs, use the supported options of the correct binary and enable 'use-locale' in the test framework, ensuring that it is only specified when the related binary supports it.