When Changing the Character Set Changes the Character Width

If the character set change involves a change of character width, reload the stored procedure messages of all databases controlled by the Replication Server.

The stored procedure messages are in $SYBASE/$SYBASE_REP/scripts/rsspmsg1.sql and rsspmsg2.sql for UNIX, and %SYBASE%\%SYBASE_REP%\scripts\rsspmsg1.sql and rsspmsg2.sql for Windows.

For UNIX

When the change is from a single-byte to a multibyte character set:

isql -Uuser_name -Ppassword -Srssd_name -Jeucjis
< $SYBASE/$SYBASE_REP/scripts/rsspmsg2.sql

When the change is from a multibyte to a single-byte character set:

isql -Uuser_name -Ppassword -Srssd_name -Jiso_1
< $SYBASE/$SYBASE_REP/scripts/rsspmsg1.sql

For Windows

When the change is from a single-byte to a multibyte character set:

isql -Uuser_name -Ppassword -Srssd_name -Jeucjis
< %SYBASE%\%SYBASE_REP%\scripts\rsspmsg2.sql

When the change is from a multibyte to a single-byte character set:

isql -Uuser_name -Ppassword -Srssd_name -Jiso_1
< %SYBASE%\%SYBASE_REP%\scripts\rsspmsg1.sql

When the change is to the UTF-8 character set, install both rsspmsg1.sql and rsspmsg2.sql