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

utf8_general_ci/utf8_bin

    XMLWordPrintable

Details

    • Task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • N/A
    • OTHER
    • None

    Description

      Hi ,

      Sorry if the issue type is wrong. I want to do a case sensitive search on my tables so planning to re-create all the tables with UTF8_BIN.

      Can you suggest which among the 2 solution's is better?
      1) Re-create the table with UTF8_BIN?
      2) select * from test where name collate 'utf8_bin' like 'abc';

      Also can you let me know the advantages and disadvantages of using collation utf8_general_ci and utf8_bin performance wise or storage wise or any other factors

      Attachments

        Activity

          People

            serg Sergei Golubchik
            Manasa ManasaTulluri
            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.