Browse > Home / Programming services / How to change collation on all tables in MySQL at Wordpress – easy script

How to change collation on all tables in MySQL at Wordpress – easy script

November 16, 2008

How to change collation on all tables in MySQL at Wordpress ?

So how to solve problem ?  You need to set all your database tables  to   utf8_unicode_ci !!!

Database name, password and user name you will copy from wp-config at wordpress.

1)  DOWNLOAD script for database collation

2) Unzip the zip file and copy the folder ‘tool_phoca_changing_collation’ into your server (localhost). Run the index.php script included in the ‘Collation’ folder. Add the following information into the form:

  • Database hostname (e.g. localhost)
  • Database username
  • Database password
  • Database name
  • Database collation (add here the collation you want to have for the database, all tables and all columns in all tables.

In 30 seconds everything will be done !!! read at more : How to change collation on all tables and columns in MySQL – easy script

Write comments if you have better tips.

Related Posts

  1. iTunes visual basic script, a playlist for every folder
  2. Wordpress.com allows to upload videos and HD as extra functionality
  3. 60 great free Wordpress themes
  4. 10 requests to improve WordPress
  5. Sun Microsystems Strikes Multi-Million Dollar Deal With Leading ERP Software Company to Deploy MySQL(TM) Enterprise and GlassFish(TM) Solutions : New Customer Stésud Deploys Open Source Application Server and Database Platform to Reduce Enterprise IT Costs and Improve Overall Performance
  6. The 18 most downloaded plugin for Wordpress
  7. WordPress 2.7
  8. Creative sites made with Wordpress
  9. Announced the new version 1.2 of Wordpress for iPhone
  10. Last Logon Exchange 2007, IP and other details with Shell Exchange
  11. Lightbox Plugin for Automatic Wordpress
  12. Web template Murah | Script siap pakai | Joomla template
  13. More information, confirmed the case Jazztel / WordPress.com
  14. Technology – WBC Software Lab
  15. Different content depending on the Website on Wordpress
  16. Social commentary: Testing Disqus
  17. 5 galleries for Wordpress Themes
  18. Blocked by Jazztel WordPress.com ¿?
  19. Basic services at Web Soft Design

Written by · Filed Under Programming services