Title: encoding problems ?
Last modified: August 22, 2016

---

# encoding problems ?

 *  [numero7](https://wordpress.org/support/users/numero7/)
 * (@numero7)
 * [11 years, 1 month ago](https://wordpress.org/support/topic/encoding-problems-7/)
 * Hi i have two problems with the export tool maybe you can help :
 * 1) i cannot set a field delimiter for the exported csv, because the fields uses
   coma separator and there’s comas in the text, i suspect i cause problems… is 
   it possible to set another separator ?
 * 2) the accent are not taken in utf8. As we use french all accent are transformed
   on the csv file (for example : journée is transformed as journée).
 * I don’t know what to do, could you help me ? thanks a lot and have a nice day
 * [https://wordpress.org/plugins/contact-form-7-to-database-extension/](https://wordpress.org/plugins/contact-form-7-to-database-extension/)

Viewing 3 replies - 1 through 3 (of 3 total)

 *  Plugin Author [Michael Simpson](https://wordpress.org/support/users/msimpson/)
 * (@msimpson)
 * [11 years, 1 month ago](https://wordpress.org/support/topic/encoding-problems-7/#post-5944661)
 * (1) Comma in the text should not be a problem because all the entries are quoted
   like:
 * `"Value 1", "value 2, which as a comma inside the quotes", "value 3"`
 * And quotes inside the value should be escaped as well.
 * (2) Generally I find the accents work for me, but my MySQL DB table for CFDB 
   is set to UTF-8. The resulting export file should be UTF-8 but if it is not stored
   that way in the DB, it might get mixed up.
 *  Thread Starter [numero7](https://wordpress.org/support/users/numero7/)
 * (@numero7)
 * [11 years, 1 month ago](https://wordpress.org/support/topic/encoding-problems-7/#post-5944756)
 * Hi i think it’s a excell problem, iv’e downloaded openoffice and the file is 
   correctly displayed… i don’t know why.
 * anyway thanks a lot for your quick reply.
 *  Plugin Author [Michael Simpson](https://wordpress.org/support/users/msimpson/)
 * (@msimpson)
 * [11 years, 1 month ago](https://wordpress.org/support/topic/encoding-problems-7/#post-5944813)
 * Excel might expect the BOM characters at the beginning of the file. Try using
   the Excel CSV or Excel TSV exports for that, and Plain CSV for OpenOffice and
   any other CSV reader.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘encoding problems ?’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/contact-form-7-to-database-extension_ffffff.
   svg)
 * [Contact Form DB](https://wordpress.org/plugins/contact-form-7-to-database-extension/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/contact-form-7-to-database-extension/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/)
 * [Active Topics](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/reviews/)

## Tags

 * [separator](https://wordpress.org/support/topic-tag/separator/)

 * 3 replies
 * 2 participants
 * Last reply from: [Michael Simpson](https://wordpress.org/support/users/msimpson/)
 * Last activity: [11 years, 1 month ago](https://wordpress.org/support/topic/encoding-problems-7/#post-5944813)
 * Status: not resolved