All entities must be encoded in XML in the SQL To Parameters action code.
You may want to use special characters in your code. Thus you need to replace special characters with their XML equivalent.
Two cases have to be considered :
- the character is one of the 5 predefined XML entities :
For those characters, you have to replace the character with its reference :
In this example, to have the string 'GIBBS&Jason', we need to set 'GIBBS&Jason' :
- the character is NOT one of the 5 predefined XML entities :
For all other characters, you have to replace the character with a string containing its decimal number reference.
You'll find here the list of characters entities references (see paragraph 'Character entity in HTML'). Hereafter is an extract :
To have a 'é', you need to write 'é' where 233 is the corresponding parenthesized decimal number.
In this example, to have the string 'frais généraux', you need to set 'frais généraux"