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

Change collation and character set

    XMLWordPrintable

Details

    • New Feature
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • Character Sets
    • None

    Description

      I want to change the character set and collation of my columns, tables, and database. So far, the only option I have is to alter each column, table, and the database individually.
      However, this isn't working because there are foreign key constraints applied. I don't want to drop and recreate them, as my database is 650 GB in size and contains around 2,500 foreign keys.

      Disabling foreign key checks is also not working.
      Is there any other way to do this?

      Attachments

        Activity

          People

            Unassigned Unassigned
            Soumya Eligeti Soumya
            Votes:
            0 Vote for this issue
            Watchers:
            0 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.