Announcement

Collapse
No announcement yet.

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

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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

  • #2
    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.
    Albert Drent
    aducom software netherlands
    scriptcase partner, reseller, support and (turn-key) development
    www.scriptcase.eu / www.scriptcase.nl

    Comment


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

      Comment

      Working...
      X