Update the wp_posts_idx table default collate
-
The IDX Broker plugin creates a table called wp_posts_idx upon activation. It would be really great if you could update the plugin to set the collate to match what WordPress defaults to using. Curently the IDX Broker plugin sets the table to use “latin1_swedish_ci” which is MySQL’s default, while WordPress defaults to “utf8_general_ci”.
I also suggest running an update function so all sites already using the plugin will get this update, not just sites installing/activating the plugin for the first time.
I found a good article explaining the issues a bit more:
http://webdesign.anmari.com/2791/wp-foreign-characters-php-creating-tables/Also can you please look into setting up uninstall.php in the plugin to remove the table (and any options) when the user deletes the plugin.
https://developer.wordpress.org/plugins/the-basics/uninstall-methods/
- The topic ‘Update the wp_posts_idx table default collate’ is closed to new replies.
