Forms do not support characters with accents (French)

[dand33]

Hi,

Form Tools is an excellent tool for managing web form.
But I have a problem with my French version of the web forms. Soon as I write a word with an accent the rest of the fiend does not follow in the database as well as in the admin message.

Exemple: Hélène... all I get in the database is H

My form are in "charset=iso-8859-1"... With a simple PHP script, the message I received is complete but not with Form Tools.

My database is ok because I can make a correction on a data (form subscription) the database keep the accent as I changed it. The problem seems to be in the transfer of the information from Form Tools and the database and Swift Mailer.

Could someone give me some help on this ?

Thanks a lot...

[Nowton]

Upgrade to the 2.01 beta, this will fix it.

Hi,

Form Tools is an excellent tool for managing web form.
But I have a problem with my French version of the web forms. Soon as I write a word with an accent the rest of the fiend does not follow in the database as well as in the admin message.

Exemple: Hélène... all I get in the database is H

My form are in "charset=iso-8859-1"... With a simple PHP script, the message I received is complete but not with Form Tools.

My database is ok because I can make a correction on a data (form subscription) the database keep the accent as I changed it. The problem seems to be in the transfer of the information from Form Tools and the database and Swift Mailer.

Could someone give me some help on this ?

Thanks a lot...

---

I stand corrected, we have the same problem with Spanish forms. Apparently character-escaping issues...again.

Upgrade to the 2.01 beta, this will fix it.

[Ben]

Hey guys,

No, it's probably not a character escaping issue.

Most likely, you may need to tell the server that the form request is in a particular charset. Try adding the following attribute to your form tag:

<form ... accept-charset="UTF-8">

(utf8 should work fine, but you can change it to accept-charset="ISO-8859-1" if you like).

Let me know how it goes!

- Ben

[dand33]

Hi Ben,

No, sorry, it did not works
Here's the result:
First Name H?l?ne (should be Hélène)
Last Name L?veill (should be Léveillée)

My database is in Latin1_general_ci, would it be better if I change it for utf-8_general_ci ?

Thank You for your help

[Ben]

Hi dand - yes, very possibly.

After changing it, put through another submission with the French characters and see if they show up propertly (existing submissions may still not work).

- Ben

[dand33]

Very strange...
I have created another form and added the // accept-charset="ISO-8859-1" // and I still have the same results.

I can interpret the results and change it in the database but really, I don't understand...
I will continue to make some reasearch

Thank You for your help Ben...

[lsendoya]

As for formTools API 2.0.3-beta-20100731, I believe that any issues with non English characters can be solved changing the global\library.php config file at line 97:

Code:

$g_unicode = true;

the comment says clearly:

Code:

* This offers support for unicode. All form submissions will be sent as UTF-8. This is enabled for all
* new installations.

So if you have non UTF-8 forms, you should change line 97 to

Code:

$g_unicode = false;

in order to display properly non English characters or non UTF-8 forms.


Hope it helps somebody.

[dand33]

Hey Everybody...

With this ($g_unicode = false it WORKS.

Thank You All and especially the Rabbit!

[Ben]

The Rabbit is wise

(Good to know, thanks Luis!)