Do only what matters: MySQL

Edit History Tags Source

MySQL - ALTER DATABASE

ALTER DATABASE mydb CHARACTER SET latin1 COLLATE latin1_swedish_ci

Changing the default character set or collation affects only creation of new tables. It does not affect existing tables. The database name is optional. If no database is specified, then ALTER DATABASE use the default (currently selected) database. You cannot use ALTER TABLE to rename a database. One way to accomplish this is to dump the database, create a database with the new name, reload the data into the new database, and drop the old database.

page_revision: 0, last_edited: 1230334352|%e %b %Y, %H:%M %Z (%O ago)

Edit Tags History Files Print Site tools + Options

Click here to edit contents of this page.

Click here to toggle editing of individual sections of the page (if possible). Watch headings for an "edit" link when available.

Append content without editing the whole page source.

Check out how this page has evolved in the past.

If you want to discuss contents of this page - this is the easiest way to do it.

View and manage file attachments for this page.

A few useful tools to manage this Site.

See pages that link to and include this page.

Change the name (also URL address, possibly the category) of the page.

View wiki source for this page without editing.

View/set parent page (used for creating breadcrumbs and structured layout).

Notify administrators if there is objectionable content in this page.

Something does not work as expected? Find out what you can do.

General Wikidot.com documentation and help section.

Wikidot.com Terms of Service - what you can, what you should not etc.

Wikidot.com Privacy Policy.