It works OK for me. If you get an email from a form submission, see if the correct characters there. You might also use PHPMyAdmin to peek at the entry in the wp_cf7dbplugin_submits table to see if the characters are being stored correctly. When you log into PHPMyAdmin, the initial page should list the MySQL character set and collation. Things should work if they are UTF-8. If it is some other encoding, that might be the problem.
Some clues :
In mail, the characters are ok
in Phpmyadmin : characters are ok
I think you point something.
Many of my tables are in utf8_general_ci but wp_cf7dbplugin_submits is in latin1_swedish_ci
I use : ALTER TABLE wp_cf7dbplugin_submits
CONVERT TO CHARSET utf8 COLLATE utf8_general_ci ;
But still don’t work?
Once the table is converted, post a new entry with é, è, à. See if that new entry appears correctly. Older entries may be corrected.
Hi Michael,
Hi initiateur,
I’ve got the same problem with special characters in german.
Tested everything … changed the collation of my table (it also shows latin1_swedish_ci) to utf8_general_ci and posted a new entry. E-Mail looks ok, Phpmyadmin looks ok, Website looks not ok. The whole cell in contact form db stays empty.
Maybe it’s a problem caused by WordPress? My version is 3.83 at the moment. On my Lab I’ve upgraded it from 3.83 to 3.9.1. After the upgrade the problem occurs. If I only upgrade all my plugins and stay at 3.83 the problem didn’t occurs.
Any suggestions?
– Markus
Same here, cell still empty
WordPress 3.9.1
Contact Form DB : 2.7.5
Fast Secure Contact Form : 4.0.20
PHP Version : 5.5.13
MySQL Version : 5.5.14
Already have <meta charset=”UTF-8″> in my <head>
Me too!
Maybe it’s caused by the way contact form db outputs the data into the cell? As I said: in version 3.83 everything works fine. If I upgrade my version to 3.9.1 the issue occurs. No other changes made.
Luckily I’m running my Lab on vmWare so I’m able to restore fast to a restore point where version 3.83 is running.
Another clue :
When I try to export data :
In HTML, Excel Internet Query, Excel CVS : CELLS still empty
In Google Spreadsheet live data : text is ok but with some ? where caracter with accent should be.
In your wp-config.php file, do you have an entry like:
define('DB_CHARSET', 'utf8');
define(‘DB_CHARSET’, ‘utf8’);
Yes sir !
Me too!
I’ve read some other posts on the internet and disabled this entry in my wp-config.php file. No change at all!
Some users recommended define('DB_CHARSET', ''); but this also changed nothing regarding my problem with german special characters (“umlaut” characters like ä,ö,ü).
I’ve played around a little bit without a clue what is causing this problem.
In version 3.83 everything works fine (without changing collation of the cfdb table or something). After upgrade to version 3.9.1 the issue occurs.
I haven’t found any other post regarding this problem. And I’ve searched a lot.
Any suggestions?
I would like to upgrade to V3.9.1 of WordPress. But only if CFDB works as it does before. 😐
I haven’t been able to duplicate the problem. It works OK for me. And I haven’t been able to ascertain what is different about your configuration that would cause the problem. I don’t have a solution for you.
Thanks for your support, Michael. I really appreciate your work and your support.
I’ve asked my question regarding this problem in the localhost forum on the wordpress support forums. A support member comes to the conclusion that the problem might be caused by the CFDB plugin and not by the wordpress core.
Now I’m left in the middle of nowhere and do not know where to go …
Please have a look at his thread if you got the time to read it.
Every help would be very appreciated. I do not want to stay at Version 3.8.3 with an unsolved problem. 🙁
Is the problem still also there at your installation, initiateur???
