Oracle and ListManager (Unix)

Before installing ListManager, you’ll need to install the Oracle Client Tools (or Basic Client Software) on the machine which will be running ListManager. Then, you’ll create a user and password to be used by ListManager. When you’re done, you’re ready to install ListManager. Your DBA can assist you in installing the client software on the

Case Sensitivity and Oracle

The default Oracle installation sets the database to be case-sensitive. We recommend that you use a case-insensitive databaser for ListManager.

Changing the Character Set of your Oracle Instance

Oracle servers, by default, do not install with a character set that allows 8-bit ASCII characters to be represented correctly. Any high ASCII characters (greater than 127) are translated into other characters. This can cause a problem if you expect that any mail flowing through ListManager will use special accent characters, such as ˙ or á.

To get around this problem, create your Oracle instance with an 8-bit ASCII character set. If you don't have a preference, we recommend you use:
 

WE8ISO8859P1

This character set appears to also be the one used by Windows as its default, so if both client and server are set to use the same character set, you need not worry about characters being translated.

However, if you choose a different character set, the data will be translated into the client character set, which will almost certainly cause problems. The client character set can be configured using an environmental variable called NLS_LANG. The syntax of the variable is <language>_<country>.<char set>, such as
 

American_America.US8PC437

Setting the Environment Variable for Unix

For a UNIX client, set the environment variable in this manner:

csh/tcsh: setenv NLS_LANG 'American_America.US8PC437'

sh/bash: NLS_LANG='American_America.US8PC437'; export NLS_LANG