Configuring the message service to use non-ASCII characters

To store, retrieve, and display non-ASCII text correctly when using the message service database, you must do one of the following:

• When you specify the Server Name for the message service connection cache, define the character set using a jConnect™ for JDBC™ URL of this form:

  jdbc:sybase:Tds:<host>:<port>?charset=<charset>
  

• Change the character set of the message service database to be consistent with the language you are using:

  1. Using a text editor, open the MessageServiceConfig.props file located in the EAServer /Repository/Component/CtsComponents directory.

  2. Change the datatype of the varchar columns in the SQL schemas to varbinary.

  3. Drop any tables that contain a column whose datatype you changed from the message service database.