To override the default character set, as of ESD #12, all of the executable scripts (or batch files) in the Mirror Replication Agent bin directory refer to an environment variable named RA_JAVA_DFLT_CHARSET. You can set this environment variable to the character set that you want. However, the character set you specify must be the same character set that is configured on the primary database. For a list of valid Java character sets, go to the Supported Encodings on the Internationalization page under Documentation for the J2SE 1.4.2 JDKhttp://java.sun.com/j2se/corejava/intl/index.jsp.
For instances created after applying ESD #12, the Mirror Replication Agent instance RUN scripts also refer to the RA_JAVA_DFLT_CHARSET environment variable.
If you are using Replication Server to replicate a number
of different character sets, you must configure it for UTF8.
To override the system default character set:
Set the value of a system variable named RA_JAVA_DFLT_CHARSET in your environment and using the ra utility to start the Mirror Replication Agent instance. By using the ra utility, allows you to override the value of the RA_JAVA_DFLT_CHARSET system variable in your environment to specify the character set,
or
Set the value of the RA_JAVA_DFLT_CHARSET variable in the Mirror Replication Agent instance RUN script and using the RUN script to start the Mirror Replication Agent instance. By using the instance RUN script (or batch file), you can edit the script to specify the default value of RA_JAVA_DFLT_CHARSET and specify the character set.
To override the system default character set for
all instances
Enter a character set value in the ra script:
For Windows, edit the %SYBASE%\MRA-12_6\bin\ra.bat file
For UNIX, edit the $SYBASE/MRA-12_6/bin/ra.sh file
RA_JAVA_DFLT_CHARSET=charset
where charset is the Java-supported encoding.
For example, ISO8859_1
or Cp1252
for
ISO-1 (also known as Latin-1), and ISO8859_8
or Cp1255
for
Hebrew.
Uncomment the following lines of code:
For Windows:
set RA_JAVA_DFLT_CHARSET=charset
For UNIX:
RA_JAVA_DFLT_CHARSET=charset export RA_JAVA_DFLT_CHARSET
To override the system default character set for
a Mirror Activator Agent instance
Enter a character set value in the RUN script:
For Windows, edit the %SYBASE%\MRA-12_6\<instance>\RUN_<instance>.bat batch file:
set RA_JAVA_DFLT_CHARSET=charset
For UNIX, edit the $SYBASE/MRA-12_6/<instance>/RUN_<instance>.sh script:
RA_JAVA_DFLT_CHARSET=charset export RA_JAVA_DFLT_CHARSET
where charset is the Java-supported encoding.
For example, ISO8859_1
or Cp1252
for
ISO-1 (also known as Latin-1), and ISO8859_8
or Cp1255
for
Hebrew.
In UNIX, spaces are not allowed on either side of the
equal sign. For a list of valid Java character sets, refer to Supported
Encodings on the Internationalization page under Documentation for
the J2SE 1.4.2 JDKhttp://java.sun.com/j2se/corejava/intl/index.jsp.