Non asci characters in data input mishandled
There are a number of problems in the system when data is loaded containing non
asci characters eg. è,ù,ö
1) The database throws errors when queried using a string containing one these
2) XML is transformations fail on XML containing these values.
This is going to take some investigation to overcome. I hate these kind of
#2 Updated by Gabriel Farrell over 19 years ago
The database doesn't have a problem with the characters ... it has a problem
when data contains single or double quotes as part of a string.
This should be fixable by filtering out these before writing to the database and
reconsituting them when reading from the database.
#3 Updated by Gabriel Farrell over 19 years ago
No longer blocks bug956 since the single quotes and other postgres special
characters $ and ^ and escaped before going into the database.
Leaving the bug open as I need to impliment the removal of the escape character
upon read the data from the database (hoped this would happen automatically) and
the xml problem with special characters remains.