Locales and loading data using the XML loader
The current schema creation script creates seven locales as part of the table creation script. You should review this part of the table creation script and modify it to remove locales if need be before running the script.
For each locale, you must take care to ensure that the correct value in the DB_SORT_LOCALE_NAME column of the CMGT_LOCALE table is set.
The following database sorting settings table summarizes the most frequently used values for this column:
| Database | Locale | Value |
|---|---|---|
| Oracle | en_US | BINARY |
| de_DE | XGERMAN | |
| fr_FR | XFRENCH | |
| fr_CH | BINARY | |
| de_CH | BINARY | |
| ja_JP | BINARY | |
| zh_TW | BINARY |
For other locales, please contact your customer support representative for further information. Db2® does not require these settings: the database sort order is set at the database level and cannot be changed.