Please note the below points while installing the “Latin1 to UTF-8 Converter 1.0:

1. This should be installed only once on top of SapphireIMS Patch 4081 and above

2. If the SapphireIMS Application and MySQL Database are installed on two different servers then install the “Latin1 to UTF-8 Converter” on the SapphireIMS Application Server

3. Please use “Run as administrator” option to install the “Latin1 to UTF-8 Converter” on Windows OS above Windows XP and Windows Server 2003

4. The “Latin1 to UTF-8 Converter” Installer doesn’t have the mechanism to check if it has already been installed earlier. Please ensure it is installed only once

5. Before installing the “Latin1 to UTF-8 Converter” please ensure that the MySQL Service is Running and SapphireIMS Service is Stopped

6. After the installation start the SapphireIMS Service

7. For Windows: If the Database Server is installed in a different machine then the following changes should be done after installing the “Latin1 to UTF-8 Converter” in the “my.ini” file of the remote MySQL Server where the database is hosted:

# The “my.ini” file will be present in the path “<Install Path>\MySQL Server 5.5”. Before performing the changes in the “my.ini” file, take the backup of the “my.ini” file and store it in a different folder
# Stop the MySQL Service and do the following changes in the appropriate sections of the “my.ini” file. If the key variable is already present, please ensure the value is changed to “utf8”:

[Client]
default-character-set=utf8
[mysqld]
character-set-server=utf8
           
8. For Linux: If the Database Server is installed in a different machine then the following changes should be done after installing the “Latin1 to UTF-8 Converter” in the “my.cnf” file of the remote MySQL Server where the database is hosted:

# The “my.cnf” file will be usually present in the path “/etc”. Before performing the changes in the “my.cnf” file, take the backup of the “my.cnf” file and store it in a different folder
# Stop the MySQL Service and do the following changes in the appropriate sections of the “my.cnf” file. If the key variable is already present, please ensure the value is changed to “utf8”:

[Client]
default-character-set=utf8
[mysqld]
character-set-server=utf8”