Charset

I have a problem with charset of text inserted by form in mysql db.

The e-mail submitted by form after submit is ok but the data in database not.

The records in DB is like this (phpMyAdmin screenshot):
https://www.dropbox.com/s/pkprqs9o1gpmcx4/Screenshot%202014-01-29%2021.15.06.png

The data seems "corrupted" ( https://www.dropbox.com/s/8r1cwhv3bn7srl8/Screenshot%202014-01-29%2021.19.47.png ); the correct word is "può" but is displayed "puA2".

Where I wrong ?

Thank, Andrea.

Hi Andrea,

Please check the default collation for the database schema, it needs to be UTF-8. ChronoForms does not specifically set a collation when it creates a table.

Bob

Is this my problem:

[attachment=0]MySQL Variables.PNG[/attachment]

?

I need to change latin1 to utf-8, right ?

Hi Andrea,

I'm not a MySQL expert but I think that will fix the problem. If there is important data in the table then test on a new table first. I think that you can change the setting either for the whole schema (database) or for each table.

Bob