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

Storage Requirements for varchar

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • None
    • N/A
    • Documentation
    • None

    Description

      I think that there is a wrong assertion in documentation about Storage Requirements for varchar datatypes.

      https://mariadb.com/kb/en/mariadb/data-type-storage-requirements/

      Documentation says (in "String data types" section):

      Data Type: VARCHAR(M), VARBINARY(M)
      Storage Requirement: M + 1 bytes if column is 0 – 255 bytes, M + 2 bytes if column may require more than 255 bytes

      As I am concern, this should be:

      Data Type: VARCHAR(M), VARBINARY(M)
      Storage Requirement: len + 1 bytes if column is 0 – 255 bytes, len + 2 bytes if column may require more than 255 bytes

      So space depends on actual value length (len) and not actual definition (M)...

      Attachments

        Activity

          People

            greenman Ian Gilfillan
            nico Nicolas Payart
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.