Title: SQL CHARACTER SET
Last modified: August 21, 2016

---

# SQL CHARACTER SET

 *  Resolved [AYEUNG](https://wordpress.org/support/users/ayeung/)
 * (@ayeung)
 * [12 years, 1 month ago](https://wordpress.org/support/topic/sql-character-set/)
 * Hi Author,
 * Can this plugin change DEFAULT CHARACTER SET of SQL
 * from utf8_general_ci to COLLATE** utf8_unicode_ci**
 * [https://wordpress.org/plugins/all-in-one-wp-security-and-firewall/](https://wordpress.org/plugins/all-in-one-wp-security-and-firewall/)

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

 *  [mra13 / Team Tips and Tricks HQ](https://wordpress.org/support/users/mra13/)
 * (@mra13)
 * [12 years, 1 month ago](https://wordpress.org/support/topic/sql-character-set/#post-4754200)
 * Yeah sure. We will try to do it in our next version.
 *  Thread Starter [AYEUNG](https://wordpress.org/support/users/ayeung/)
 * (@ayeung)
 * [12 years, 1 month ago](https://wordpress.org/support/topic/sql-character-set/#post-4754242)
 * Good job. Wait for your good news.
 *  Thread Starter [AYEUNG](https://wordpress.org/support/users/ayeung/)
 * (@ayeung)
 * [12 years, 1 month ago](https://wordpress.org/support/topic/sql-character-set/#post-4754255)
 * also , ENGINE=MyISAM can it change to ENGINE=InnoDB , for your consider on next
   update .
 *  Thread Starter [AYEUNG](https://wordpress.org/support/users/ayeung/)
 * (@ayeung)
 * [12 years, 1 month ago](https://wordpress.org/support/topic/sql-character-set/#post-4754342)
 * v3.7.2 new released solved
 *  [pixelmajic](https://wordpress.org/support/users/pixelmajic/)
 * (@pixelmajic)
 * [11 years, 10 months ago](https://wordpress.org/support/topic/sql-character-set/#post-4754378)
 * How can I stop the plugin from changing ENGINE from MyISAM to InnoDB? My db backups
   can’t be restored on my host account because, the SQL database doesn’t support
   it.
 * **I need all my table to use ENGINE=MyISAM**
 * Thanks,
 * Travis
 *  Thread Starter [AYEUNG](https://wordpress.org/support/users/ayeung/)
 * (@ayeung)
 * [11 years, 9 months ago](https://wordpress.org/support/topic/sql-character-set/#post-4754383)
 * This plugin use ENGINE=MyISAM as DEFAULT already , wp use InnoDB as Default. 
   both engine can run fine on one date base.

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

The topic ‘SQL CHARACTER SET’ is closed to new replies.

 * ![](https://ps.w.org/all-in-one-wp-security-and-firewall/assets/icon-256x256.
   png?rev=2798307)
 * [All-In-One Security (AIOS) – Security and Firewall](https://wordpress.org/plugins/all-in-one-wp-security-and-firewall/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/all-in-one-wp-security-and-firewall/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/all-in-one-wp-security-and-firewall/)
 * [Active Topics](https://wordpress.org/support/plugin/all-in-one-wp-security-and-firewall/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/all-in-one-wp-security-and-firewall/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/all-in-one-wp-security-and-firewall/reviews/)

## Tags

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

 * 6 replies
 * 3 participants
 * Last reply from: [AYEUNG](https://wordpress.org/support/users/ayeung/)
 * Last activity: [11 years, 9 months ago](https://wordpress.org/support/topic/sql-character-set/#post-4754383)
 * Status: resolved