How Db2 derives locales

Linux and UNIX

On Linux® and UNIX systems, the active locale used by Db2 is determined from the LC_CTYPE portion of the locale. For details, see the multicultural support documentation for your operating system.
  • If LC_CTYPE of the program locale has a value other than C, Db2 will use this value to determine the application code page by mapping it to its corresponding code page.
  • If LC_CTYPE has a value of C (the C locale), Db2 will set the program locale according to the environment locale, using the setlocale() function.
  • If LC_CTYPE still has a value of C, Db2 will assume the default of the US English environment, and code page 819 (ISO 8859-1).
  • If LC_CTYPE no longer has a value of C, its new value will be used to map to a corresponding code page.

Windows

On Windows systems, the active locale used by Db2 is determined by the regional and language options, specified using the Control Panel. The dialog for these options depends on the version of the Windows operating system. For example, this dialog is called Regional Options on a Windows 2000 system and Regional and Language Options on a Windows 7 system. For details, see the multicultural support documentation for your operating system.