StarTeam Server stores UTF-8 data in Oracle schema users. StarTeam Server does not use the Oracle conversion mechanism. It performs the conversion to UTF-8 itself.
Oracle software does the conversion only when the Oracle Client’s character set (specified by NLS_LANG) does not match the database instance’s character set. Therefore, it is very important that the client and server’s settings match. StarTeam Server configurations require that Oracle database instances use the WE8MSWIN1252 character set. If your StarTeam Server database was previously Oracle 8i, then Oracle database instances use the WE8ISO8859P1 character set. StarTeam Server also supports AL32UTF8 character set.
The Server Administration tool does not allow you to create a new StarTeam Server server configuration unless the underlying database instance’s character set is the correct character set. When StarTeam Server starts, it also ensures that the database character set matches the characters set portion of NLS_LANG.
Due to the numeric setting differences between different languages and territories, StarTeam Server also does not start unless AMERICAN_AMERICA (the US numeric setting) is the setting for the language_territory portion of NLS_LANG. Failure to do so causes exceptions for StarTeam Server. This does not mean that numbers and so on will be displayed incorrectly. For example, in Germany and other countries, a decimal point is represented as a comma. Such numbers will still display correctly.