Cannot put non-UK characters in an XML script
Hint Ref: 020912100001
Hint Date: 10/12/2009
Hint Details:
PROBLEM
When writing an XML script, for example to email a customer, there is often a need to include non-UK characters. These can cause a load error when trying to run the script.
SOLUTION
Please paste the following line into the script above the <Job> statement. In most cases it will allow these characters to be used.
<?xml version="1.0" encoding="iso-8859-1"?>
If an ?xml line already exists, try changing the encoding.
Sometimes the solution is to use a suitable encoding along with the <![CDATA[....]]> statements
(Please Note: This Procedure can be destructive and should only be used by Advanced Users. RADical Systems (UK) Limited or its Partners cannot be held responsible, in anyway, for any consequence of using this or any other Database Function, Procedure or SQL command. Responsibility resides solely with the user.
IT IS HIGHLY RECOMMENDED THAT A FULL AND VALID SPACE MANAGER DATABASE BACKUP IS TAKEN AND VERIFIED AS VALID BEFORE MAKING ANY CHANGES TO THE DATABASE.)