Title: UTF-8 problems, again Last modified: August 10, 2021 --- # UTF-8 problems, again * [Douglas “BearlyDoug” Hazard](https://wordpress.org/support/users/bearlydoug/) * (@bearlydoug) * [4 years, 10 months ago](https://wordpress.org/support/topic/utf-8-problems-again/) * Last July, [@ivijanstefan](https://wordpress.org/support/users/ivijanstefan/) provided a fix for some characters ([see this thread](https://wordpress.org/support/topic/utf-8-csv-export-fix/)), however, it doesn’t go far enough. * Stored in DB: `Jennifer, my cousin’s daughter–although` * Actual exported line: `Jennifer, my cousin’s daughter–although` * What’s interesting is that it’s recommended to not use the HTML entity for the comma, rather, to use the character entity, instead. [See this thread](https://answers.microsoft.com/en-us/msoffice/forum/all/apostrophe/34c7125e-eee1-43b5-957c-bfeb004a61f3) on Microsoft’s support site. * Can we get a manual fix for this, ASAP, please? * (I appreciate your time and help with this, Arshid. 🙂 ) * Thanks! - This topic was modified 4 years, 10 months ago by [Douglas "BearlyDoug" Hazard](https://wordpress.org/support/users/bearlydoug/). - This topic was modified 4 years, 10 months ago by [Douglas "BearlyDoug" Hazard](https://wordpress.org/support/users/bearlydoug/). - This topic was modified 4 years, 10 months ago by [Douglas "BearlyDoug" Hazard](https://wordpress.org/support/users/bearlydoug/). - This topic was modified 4 years, 10 months ago by [Douglas "BearlyDoug" Hazard](https://wordpress.org/support/users/bearlydoug/). Viewing 8 replies - 1 through 8 (of 8 total) * Plugin Author [Arshid](https://wordpress.org/support/users/arshidkv12/) * (@arshidkv12) * [4 years, 10 months ago](https://wordpress.org/support/topic/utf-8-problems-again/#post-14755565) * Please upload to Google drive and check it. * Thread Starter [Douglas “BearlyDoug” Hazard](https://wordpress.org/support/users/bearlydoug/) * (@bearlydoug) * [4 years, 10 months ago](https://wordpress.org/support/topic/utf-8-problems-again/#post-14756023) * Upload what? I didn’t provide any fixes. I’m asking that this be fixed. 🙂 * Plugin Author [Arshid](https://wordpress.org/support/users/arshidkv12/) * (@arshidkv12) * [4 years, 10 months ago](https://wordpress.org/support/topic/utf-8-problems-again/#post-14757996) * Please upload CSV to google drive and check it. * Thread Starter [Douglas “BearlyDoug” Hazard](https://wordpress.org/support/users/bearlydoug/) * (@bearlydoug) * [4 years, 10 months ago](https://wordpress.org/support/topic/utf-8-problems-again/#post-14758058) * I cannot do that, because that would violate our privacy policy. * I did, however, quote a part of one of the lines, directly from the database, and from the CSV above. * Plugin Author [Arshid](https://wordpress.org/support/users/arshidkv12/) * (@arshidkv12) * [4 years, 10 months ago](https://wordpress.org/support/topic/utf-8-problems-again/#post-14758069) * Create a test form from localhost and try it. * Thread Starter [Douglas “BearlyDoug” Hazard](https://wordpress.org/support/users/bearlydoug/) * (@bearlydoug) * [4 years, 10 months ago](https://wordpress.org/support/topic/utf-8-problems-again/#post-14759204) * Some additional information. The file is being exported as a CSV in UTF-8 format: * ``` root@lb17 17:41:41 > /data/www # file -i cfdb7-2021-08-11.csv cfdb7-2021-08-11.csv: text/plain; charset=utf-8 ``` * HOWEVER, if you open directly after downloading it, it opens it up in a non UTF- 8 format. My coworker was kind enough to provide a workaround for this: * ``` Instructions are: 1. Open new excel file 2. From the Data Tab -> Click “From Text/CSV” 3. Point to the file downloaded 4. On the Next Page -> file origin to 65001-Unicode (UTF-8) 5. Click load ``` * You might need to do some additional digging into this to see if you can force Excel to automatically open in UTF-8 format. * FYI, my excel version is “Microsoft® Excel® for Microsoft 365 MSO (16.0.14228.20216) 64-bit” * Thread Starter [Douglas “BearlyDoug” Hazard](https://wordpress.org/support/users/bearlydoug/) * (@bearlydoug) * [4 years, 10 months ago](https://wordpress.org/support/topic/utf-8-problems-again/#post-14759336) * UPDATE! I have a workaround! Two file edits, and this will allow CSV files to be directly opened within Microsoft Excel without having to use the special instructions above. * FILE: inc/admin-subpage.php (lines 462-464) SEARCH FOR: * ``` echo " "; _e( 'Export CSV', 'contact-form-cfdb7' ); echo ''; ``` * ADD BEFORE: * ``` /*** * @BearlyDoug (on WordPress.org) Edit: Export as Excel CSV file... */ echo ""; _e( 'Export as Excel CSV', 'contact-form-cfdb7' ); echo ''; ``` * FILE: inc/export-csv.php (lines 122-123) SEARCH FOR: * ``` foreach ($resultTmp as $key => $value): $matches = array(); ``` * ADD AFTER: * ``` /*** * @BearlyDoug (on WordPress.org) Edit: Export as Excel CSV file... */ if(isset($_REQUEST['excel']) && $_REQUEST['excel'] == "true") { $newValue = mb_convert_encoding($value, "cp1252", "UTF-8"); $value = $newValue; } ``` * There’s probably a more efficient way to handle this… possibly by simply changing the charset to cp1252 (AKA Windows-1252). I’ll test that functionality now, and will report back in a new reply. * Hope this helps! - This reply was modified 4 years, 10 months ago by [Douglas "BearlyDoug" Hazard](https://wordpress.org/support/users/bearlydoug/). - This reply was modified 4 years, 10 months ago by [Douglas "BearlyDoug" Hazard](https://wordpress.org/support/users/bearlydoug/). - This reply was modified 4 years, 10 months ago by [Douglas "BearlyDoug" Hazard](https://wordpress.org/support/users/bearlydoug/). * Thread Starter [Douglas “BearlyDoug” Hazard](https://wordpress.org/support/users/bearlydoug/) * (@bearlydoug) * [4 years, 10 months ago](https://wordpress.org/support/topic/utf-8-problems-again/#post-14759362) * Okay, I’ve tried changing * ``` header("Content-Encoding: UTF-8"); header("Content-Type: text/csv; charset=UTF-8"); ``` * to cp1252, CP1252, windows-1252 and Windows-1252 with no luck. * I’ll have to defer to you how best to implement my suggested change in a more efficient manner, [@arshidkv12](https://wordpress.org/support/users/arshidkv12/). 🙂 Viewing 8 replies - 1 through 8 (of 8 total) The topic ‘UTF-8 problems, again’ is closed to new replies. * ![](https://ps.w.org/contact-form-cfdb7/assets/icon-256x256.png?rev=1619878) * [Database Addon for Contact Form 7 - CFDB7](https://wordpress.org/plugins/contact-form-cfdb7/) * [Frequently Asked Questions](https://wordpress.org/plugins/contact-form-cfdb7/#faq) * [Support Threads](https://wordpress.org/support/plugin/contact-form-cfdb7/) * [Active Topics](https://wordpress.org/support/plugin/contact-form-cfdb7/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/contact-form-cfdb7/unresolved/) * [Reviews](https://wordpress.org/support/plugin/contact-form-cfdb7/reviews/) * 8 replies * 2 participants * Last reply from: [Douglas “BearlyDoug” Hazard](https://wordpress.org/support/users/bearlydoug/) * Last activity: [4 years, 10 months ago](https://wordpress.org/support/topic/utf-8-problems-again/#post-14759362) * Status: not resolved