If you are using MySQL, following steps could help you. 1) Save the latin1 data: mysqldump --user=name --password=pwd --default-character-set=latin1 -- skip-set-charset dbname > dump.sql
2) Create a UTF8 database: CREATE DATABASE dbname CHARACTER SET utf8 COLLATE utf8_general_ci; 3) Import the saved latin1 data into the UTF8 database: mysql --user=name --password=pwd --default-character-set=utf8 dbname < dump.sql Hope that helps, Michael On 29 Okt., 16:31, cakeFreak <[EMAIL PROTECTED]> wrote: > Hey guys, > > I need to convert all tables of an old site from latin1_general_ci (or > latin1_swedish_ci) to utf8_unicode_ci > > Is there a convenient way/script that you would suggest to perform > this task in order to avoid to fill pages with strange chars?!? > > Cheers in advance! > > Dan --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
