[thelist] mySQL - mass change of collation

Jon Molesa rjmolesa at consoltec.net
Sun Apr 29 21:19:55 CDT 2007


My first thought was:

If your backups were from mysqldump or are contained in sql/text files
then adding a CHARSET=utf8 should take care of it.

The a google for [mysql charset] returned this bit of info:

http://yoonkit.blogspot.com/2006/03/mysql-charset-from-latin1-to-utf8.html

HTH

* Jeremy Weiss <eccentric.one at gmail.com> wrote:

> Short version:
> Is there way to construct a SQL statement that I can run that would change
> the collation for all the tables and all the fields in those tables?
> 
> Extended version:
> I recently switched hosting companies during which time I backed up my DBs
> for multiple Drupal based sites and then reloaded the info on the new server
> at the new host. However, it seems that the default collation on the new
> host's db server is latin1_swedish_ci rather than utf8_general_ci. This is
> causing several problems with the Drupal sites, the primary one being that
> you can't log in. I've gone through (using phpMyAdmin) and manually switched
> everything on one site, but it took me several hours. Is there way to
> construct a SQL statement that I can run that would change the collation for
> all the tables and all the fields in those tables?
> 
> TIA,
> -jeremy
> 
> -- 
> 
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
> 
> For unsubscribe and other options, including the Tip Harvester 
> and archives of thelist go to: http://lists.evolt.org 
> Workers of the Web, evolt ! 

-- 
Jon Molesa
rjmolesa at consoltec.net
if you're bored or curious
http://rjmolesa.com



More information about the thelist mailing list