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
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
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
All C++ clients must call
setlocale() with an empty string to initialize the client with information about the current locale settings. For example:
|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.|