Title: ANSI code/ character set
Last modified: September 6, 2016

---

# ANSI code/ character set

 *  Resolved [David user](https://wordpress.org/support/users/david-user/)
 * (@david-user)
 * [9 years, 8 months ago](https://wordpress.org/support/topic/ansi-code-character-set/)
 * Great plugin! I work with spanish customers so I get special characters (á,ñ,
   í, ü). When exporting .csv how can I select UTF-8_spanish_ci character set? I
   have tried utf8_spanish and UTF-8_spanish_ci in the “code page” section but I
   get gibberish. Any pointers would be greatly appreciated. Thanks in advance! 
   David

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

 *  Plugin Author [algol.plus](https://wordpress.org/support/users/algolplus/)
 * (@algolplus)
 * [9 years, 8 months ago](https://wordpress.org/support/topic/ansi-code-character-set/#post-8153782)
 * hi David
 * Did you create tables using “utf8_spanish_ci” ?
    You can set codepage back to“
   UTF-8” and try.
 * if you have problem with Excel , try ISO-8859-1.
 * thanks, alex
 *  Thread Starter [David user](https://wordpress.org/support/users/david-user/)
 * (@david-user)
 * [9 years, 8 months ago](https://wordpress.org/support/topic/ansi-code-character-set/#post-8154279)
 * Hi Alex!
    Fast and perfect support! It works flawlessly with ISO-8859-1 in codepage.
   I get all the special spanish and other countries'(Finland, Sweden) characters
   perfectly.
 * Thanks a lot. I am getting the pro version to be able to use the profiles, schedules
   and send with email features!
 *  Plugin Author [algol.plus](https://wordpress.org/support/users/algolplus/)
 * (@algolplus)
 * [9 years, 8 months ago](https://wordpress.org/support/topic/ansi-code-character-set/#post-8154321)
 * you’re welcome 🙂

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

The topic ‘ANSI code/ character set’ is closed to new replies.

 * ![](https://ps.w.org/woo-order-export-lite/assets/icon-256x256.png?rev=1365554)
 * [Advanced Order Export For WooCommerce](https://wordpress.org/plugins/woo-order-export-lite/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/woo-order-export-lite/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/woo-order-export-lite/)
 * [Active Topics](https://wordpress.org/support/plugin/woo-order-export-lite/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/woo-order-export-lite/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/woo-order-export-lite/reviews/)

## Tags

 * [spanish](https://wordpress.org/support/topic-tag/spanish/)
 * [utf-8](https://wordpress.org/support/topic-tag/utf-8/)

 * 3 replies
 * 2 participants
 * Last reply from: [algol.plus](https://wordpress.org/support/users/algolplus/)
 * Last activity: [9 years, 8 months ago](https://wordpress.org/support/topic/ansi-code-character-set/#post-8154321)
 * Status: resolved