Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-10081

Feature request: ALTER DATABASE CONVERT TO CHARACTER SET , like ALTER TABLE CONVERT TO CHARACTER SET

    XMLWordPrintable

Details

    • Task
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • None
    • Character Sets
    • None

    Description

      When working with 3rd party databases, the default character set of the database can get in the way when creating tables. It would be nice to be able to repair this by issuing a command like

      ALTER DATABASE database_name CONVERT TO CHARACTER SET encoding_name;

      And not have to do this for every table in the database separately, as the number of tables in a database can be rather large. The command above would then run the command

      ALTER TABLE table_name CONVERT TO CHARACTER SET encoding_name;

      On all tables in the given database.

      Attachments

        Activity

          People

            Unassigned Unassigned
            donquichote BitSmid
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.