Hello fellow MySQL friends,
I recently had the "fun" to convert some 60 tables within a DB f.e.
from latin1 to UTF8.
I did a DB conversion before that with "ALTER DATABASE db_name
CHARACTER SET utf8"
That worked wonderfully, except not as expected. ;-)
It basically converted only the database itself. so I had to do a
separate "ALTER TABLE ..." for each table.
Are you aware of a much smarter way to do this ?
(perhaps a function I missed, script, batch file etc.)
Best regards
Nils Valentin
http://www.be-known-online.com/mysql
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]