Configuring BMC Server Automation databases for a non-English locale
To use BMC Server Automation in a locale other than English, follow these guidelines:
- Configure your BMC Server Automation databases using the settings recommended by your database vendor for that language.
(Oracle only) If the database is configured for the UTF8 or AL32UTF8 character set (NLS_CHARACTERSET parameter) in a LATIN-1 locale and the CHAR schema is used as an underlying persistent schema, set the NLS_LENGTH_SEMANTICS parameter of the database to CHAR to prevent column field overflow. Set this parameter before you run the master schema script to set up the database schema. - (Oracle or SQL) If the database is configured for a multibyte locale or a non-LATIN-1 locale, when you set up the database schema, run the master script that corresponds to the nchar character set.
- If you are using SQL Server, specify the appropriate collating sequence as described in Setting up an SQL Server database schema for BMC Server Automation.
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*