infoRouter Document Management Software V8.0 - Knowledge Base Article 142

MySQL 5.0 + uses the backslash character to escape special characters. This causes unwanted results in infoRouter

To change the default "string encoding parameter", perform the following:

Open the "my.ini" file located in the MySQL installation directory with notepad.

add the NO_BACKSLASH_ESCAPES text to the "sql-mode" parameter

Example:

... 
... 
# Set the SQL mode to strict
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION,NO_BACKSLASH_ESCAPES" 
... 
... 

                        

Save the my.ini file.

Restart the MySQL Service

How to stop and start MySQL from the command line:

net stop mysql
net start mysql