Special characters are replacing punctuations in multiple line text fields in form

When using multiple line text field (VARCHAR) on a form allowing all characters with no case settings, Instead of an apostrophe I get this -> “ Instead of a quotation mark I get this -> ’

It’s kind of difficult to properly punctuate text when the html seems to not translate it correctly. Could it be the database? The database character set is set to latin1 – cp1252 West European and the collation is set at latin_swedish_ci

In general when you create a project in Scriptcase and the charactersets of your connection and application do not match you get a warning and the opportunity to correct. So you could try to create a new project and recreate this one form just to test. Using apostrophe in you field w.o. using precautions might result in a sql error. So you might be needing a htmspecialchars function or so in the beforeinsert/update event.

Actually, it was a browser issue with FF 16.0.2 on linux. Thanks again.