From Wiki

Mysql: AlterDatabase

ALTER DATABASE allows you to change the overall characteristics of a database. These characteristics are stored in the `db.opt' file in the database directory. To use ALTER DATABASE, you need the ALTER privilege on the database.

ALTER DATABASE companies CHARACTER SET latin5 COLLATE latin5_turkish_ci;
ALTER DATABASE companies DEFAULT CHARACTER SET latin5 DEFAULT COLLATE latin5_turkish_ci;

Retrieved from http://kozgun.net/wiki/pmwiki.php?n=Mysql.AlterDatabase
Page last modified on June 29, 2006, at 04:15 PM