[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