Characters like ščćž confusing the database

  • Profile Image
    Smacky
    Asked on October 27, 2011 at 02:06 AM

    I have a problem. If a person enters characters like ščćž in a blank field in the form, then there is no answer for that question in the database. In the email there are strange questionmarks instead of ščćž. Please help, because in my language (slovenian) there are characters like ščćž in persons names, addresses etc.

    When i download the database in Excel then the answer ends where one of ščćž characters should be.

    Please help!

  • Profile Image
    mliz
    Answered on October 27, 2011 at 04:44 AM

    I cloned your form and made a test using the special characters in the entries. The notification email displayed the special characters and were also included stored in the submissions. I was using the direct url of the form during the test.

    Some Czech, Slovak, and Slovenian characters are part of the Unicode character set, so you need to declare the following in the head of your webpage where the form is added:

    <meta http-equiv="content-type" content="text/html;charset=utf-8" />

    Let us know if this worked for you.

  • Profile Image
    Smacky
    Answered on October 27, 2011 at 05:03 AM

    Yes, but check out the excel file and some entries (http://www.zkst-zalec.si/utrip/Utrip-anketa.xls - column D, E for example)! The text stops when there should be ščćž. But not everywhere.

    I will try the character set you suggestet.

  • Profile Image
    allanftd
    Answered on October 27, 2011 at 06:00 AM

    Thanks Smacky, these issues should be resolved by inserting the meta tag in your webpage's head section as my colleague mliz explained earlier.

    Please let us know if you need further assistance.

    Allan
    JOTFORM SUPPORT