Skip navigation links

MySQL Forums :: Character Sets, Collation, Unicode :: Change collation of all the tables on the database server


Advanced Search

Re: Change collation of all the tables on the database server
Posted by: Nebojsha Milosavlevski ()
Date: November 03, 2008 12:15PM

Check this out: http://blog.vision4web.net/2008/11/change-collation-on-all-tables-and-columns-in-mysql/

Gerd Heinrichs Wrote:
-------------------------------------------------------
> At this moment all the collations of the tables of
> the all of the databases on the server are
> latin1_swedish_ci and i would like to change this
> on a quick way to utf8_general_ci ? Otherwise i
> have to handle each table seperate to change the
> collation, and with 35 seperated databases is that
> a hugh job. I guess this can be handled on a much
> simple way.

Options: ReplyQuote


Subject Views Written By Posted
Change collation of all the tables on the database server 17381 Gerd Heinrichs 02/07/2007 09:53AM
Re: Change collation of all the tables on the database server 11058 Nebojsha Milosavlevski 11/03/2008 12:15PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.