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

utf8 charater set doesn't affect table creation.

    XMLWordPrintable

Details

    Description

      ( First of all, sorry for my poor english. My mother tongue is not english. )

      1. Add below statement to /etc/my.cnf.d/server.cnf

      character-set-server = utf8
      collation-server = utf8_general_ci

      2. Restart DB and check character set.

      3. Create new database and move to that database.
      (e.g. CREATE DATABASE testDB; )
      (e.g. USE testDB; )

      4. Create table without 'CHARACTER SET' option.
      (e.g. CREATE TABLE testTable; )

      5. Check 'SHOW CREATE TABLE' statement result.
      ( e.g. SHOW CREATE TABLE testTable; )
      You can see 'character_set_database' value is still latin1

      In MariaDB 10.0.21, Once I set 'character-set-server = utf8', all tables are created with utf8 even though I didn't write the 'character_set' option in 'CREATE TABLE' statement. And I think this is normal.

      Please check.

      Thank you.

      Attachments

        Activity

          People

            Unassigned Unassigned
            passion053 passion053
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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