Oracle LSH UTF8 Requirements

Oracle LSH has the following character set-related required settings:

  • Database character set=UTF8. Oracle Applications Rapid Install prompts you for the database character set. You MUST set this value to UTF8. A value of UTF8 is REQUIRED. This is the ONLY opportunity you have to set this value, and you CANNOT change it later.
  • NLS_CHARACTERSET=UTF8. When you set the database character set to UTF8 during Oracle Applications Rapid Install, it automatically sets NLS_CHARACTERSET to UTF8 as well, which is correct.
  • NLS_LENGTH_SEMANTICS=BYTE. The default value for NLS_LENGTH_SEMANTICS is BYTE. Do not change this value. To use character semantics, set the LHS profile Use Character Semantics for Workarea Installation to Yes. See the chapter on setting profile values in the Oracle Life Sciences Data Hub System Administrator's Guide for information.