I’ve just had a support call from one of our users trying to insert a special character (š) for use in a Czech name on a website. But whenever he pressed the UPDATE button and previewed the content somehow it would be converted to the inverted question-mark character (¿).
Now, I know that we have got issues at St Andrews with a mismatch in character-sets between Site Manager (UTF-8) and our Oracle database (ISO-8859-1) which weren’t spotted when Site Manager was installed back in 2006, so it could have something to do with that, but I also wondered if it could have something to do with how HTMLArea handles such codes.
So I went to TOOLS > MODIFY PROFILE and changed the “Html Editor” from HTMLArea to Standard Textarea and lo and behold! when I inserted either code for š: š or & #353; and clicked on UPDATE the correct character was retained and showed correctly in Preview.
Like I said, this could simply be a local issue to St Andrews but if it’s not then I hope this helps other users. And if you have any great tips for inserting special characters please let us know.
We have scheduled work on our database later this year which should address our character set mismatch issue.
Gareth @ St Andrews











