Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 1 of 1
04-14-2011, 06:28 PM #1
- Join Date
- May 2004
- Thanked 10 Times in 10 Posts
Change Collation on all Tables and Columns
Found this great little utility if you need to change collation of a bunch of tables and columns all at once. It's called Phoca Changing Collation
I am working on a huge PHP/MySQL project and because of time constraints in the beginning I wasn't paying attention, I was just importing from MSSQL. Well I ended up with a bunch of junk, a few utf8_general_ci and a few others latin and others other ones and it was a mess when I found out today that happened.
So this little thing saved me a long time of work
Pretty cool, just gotta remember to go into it's PHP file and change the max_execution_time to something really really high if you have a lot of tables and such. I had around 200 tables with thousands of records each. So I had to change it to something like 4800 to get through all tables myself. But other than that it's pretty sweet!!
http://www.phoca.cz/phoca-changing-collation/"FORTRAN is not a language. It's a way of turning a multi-million dollar mainframe, into a $50 programmable scientific calculator."
█ █ http://www.microfastcat.com -- FastCat Software, the fastest software on the NET!
█ █ http://www.microthosting.com -- Free reseller web hosting, Hosting, VPS, FREE SMALL HOSTING!!!
█ █ http://www.microtronix-tech.com -- Web design and programming