Chapter 8: Setting up the Message Service

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.