A product that provides Unicode compliance is written using the Unicode character coding system, which means Unicode data can flow from database to client without any conversion occurring. A product that provides Unicode database support enables the database to contain Unicode characters but converts them between the database and the product. Any product that accesses the database, however, still uses a native character set.
The following sections discuss Unicode support for BMC Remedy AR System:
Unicode database support for forms
The Unicode database option enables you to have multi- and single-byte forms, data, and workflow stored in the same database or database instance.
To use BMC Remedy AR System with the Unicode database option to support multiple languages using a shared database, you must install an English version of the AR System server before you install multiple-language AR System servers.
Unicode database support in BMC Remedy AR System 7.0.00 and later enables you to use multiple languages on one AR System server. You are no longer restricted by the operating system's locale.
Unicode support for AR System database types
Each database type supported by BMC Remedy AR System supports Unicode at one of the levels listed in the following table.
Unicode support for AR System database types
Unicode support level
For these database types, you must configure the database instance before you install the new AR System database.
Note: If you use an Oracle AR System database with the Unicode database option, problems might occur if the
Specific column type
Microsoft SQL Server
Uses Unicode data types
No database configuration required.
During installation, the BMC Remedy AR System installer gives you the option of creating a Unicode database. You can safely do this if you meet the following requirements:
- You are not installing on an existing AR System database.
- Your database supports Unicode at the column or tablespace level, or you configured your database instance for databases that support Unicode at the database-instance level.
If you have a BMC Remedy AR System database, you must first migrate it to Unicode before upgrading your AR System server. If you choose the Unicode database option during an upgrade against a non-Unicode AR System database, you will corrupt your database. See Migrating your database to Unicode.
Migrating your database to Unicode
If you are upgrading a BMC Remedy AR System that already has a database, you must migrate the database to Unicode before proceeding with the BMC Remedy AR System upgrade. This ensures your data integrity.
The following procedures describe how to migrate your database to Unicode. For more details, see your database documentation.
- Migrating an Oracle database to Unicode
- Migrating a Microsoft SQL Server database to Unicode
- Migrating a DB2 database to Unicode
- Migrating a Sybase database to Unicode
To migrate an Oracle database to Unicode
Follow these general steps to migrate an Oracle database. For detailed information, see your Oracle documentation.
- Confirm that your Unicode Oracle database uses the AL32UTF8 character set.
The character set is defined during the creation of the Unicode database. There is no change of character set for an existing database. During the creation of the database, the response to the prompt for a character set is AL32UTF8. The Oracle database engine performs any conversion required during import of the original (non-Unicode) database into the new database.
Perform a full export and import of the whole database.
UTF-8 columns usually store fewer characters that non-Unicode columns. If you use UTF-8 character encoding, you might be introducing data truncation. For more information, see your Oracle documentation.
To migrate a Microsoft SQL Server database to Unicode
Follow these general steps to migrate a Microsoft SQL Server database. For detailed information, see your Microsoft SQL Server documentation.
Create columns in the target database that correspond to the source database as shown in the following table.
Source column type
Target column type
Migrate your data on a column-by-column basis.
If the database has Unicode and non-Unicode columns, BMC Remedy AR System will not work.
To migrate an IBM DB2 database to Unicode
For DB2 databases, the database character set is a configuration parameter that you cannot update. Therefore, in BMC Remedy AR System, you cannot migrate existing, non-Unicode DB2 databases to Unicode.
To migrate a Sybase database to Unicode
Follow these general steps to migrate a Sybase database. For detailed information, see your Sybase documentation.
- Export the database.
- Change the Sybase default character set to UTF8.
- Import the data back into the Sybase database.
- Update the tables that contain text columns.