Choose a Character Set

Note:

If you have already installed or upgraded Oracle Clinical, you should have already selected a character set and can skip this section.

Oracle Health Sciences supports certain character sets for each product or each combination of integrated products. For TMS, Oracle strongly recommends that you use the AL32UTF8 character set. TMS also supports UTF8, US7ASCII, WE8ISO8859P1, or any single byte character set.

TMS uses the NLS_LANG environment variable to control the language, territory, and character set used for database connections. The NLS_LANG variable concatenates the three components as LANGUAGE_TERRITORY.CHARSET.

You must select AL16UTF16- Unicode UTF-16 Universal character set as the National Character Set.

Restrictions:

• You must use the same character set on the database tier and the application tier. Otherwise, Oracle Clinical may store some special characters incorrectly in the database.
• You must set the LANGUAGE_TERRITORY components of the NLS_LANG variable to american_america.
• You must set the CHARSET component of the NLS_LANG variable to match the character set of the database.