<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="column-count-limit">
      </a>
      10.4.7 Limits on Table Column Count and Row Size
     </h3>
    </div>
   </div>
  </div>
  <p>
   This section describes limits on the number of columns in tables
        and the size of individual rows.
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <a class="xref" href="column-count-limit.html#column-count-limits" title="Column Count Limits">
       Column Count Limits
      </a>
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="xref" href="column-count-limit.html#row-size-limits" title="Row Size Limits">
       Row Size Limits
      </a>
     </p>
    </li>
   </ul>
  </div>
  <div class="simplesect">
   <div class="titlepage">
    <div>
     <div class="simple">
      <h4 class="title">
       <a name="column-count-limits">
       </a>
       Column Count Limits
      </h4>
     </div>
    </div>
   </div>
   <a class="indexterm" name="idm46045226394224">
   </a>
   <a class="indexterm" name="idm46045226392720">
   </a>
   <a class="indexterm" name="idm46045226391216">
   </a>
   <p>
    MySQL has hard limit of 4096 columns per table, but the
          effective maximum may be less for a given table. The exact
          column limit depends on several factors:
   </p>
   <div class="itemizedlist">
    <ul class="itemizedlist" style="list-style-type: disc; ">
     <li class="listitem">
      <p>
       The maximum row size for a table constrains the number
              (and possibly size) of columns because the total length of
              all columns cannot exceed this size. See
       <a class="xref" href="column-count-limit.html#row-size-limits" title="Row Size Limits">
        Row Size Limits
       </a>
       .
      </p>
     </li>
     <li class="listitem">
      <p>
       The storage requirements of individual columns constrain
              the number of columns that fit within a given maximum row
              size. Storage requirements for some data types depend on
              factors such as storage engine, storage format, and
              character set. See
       <a class="xref" href="storage-requirements.html" title="13.7 Data Type Storage Requirements">
        Section 13.7, “Data Type Storage Requirements”
       </a>
       .
      </p>
     </li>
     <li class="listitem">
      <p>
       Storage engines may impose additional restrictions that
              limit table column count. For example,
       <a class="link" href="innodb-storage-engine.html" title="Chapter 17 The InnoDB Storage Engine">
        <code class="literal">
         InnoDB
        </code>
       </a>
       has a limit of 1017
              columns per table. See
       <a class="xref" href="innodb-limits.html" title="17.21 InnoDB Limits">
        Section 17.21, “InnoDB Limits”
       </a>
       .
              For information about other storage engines, see
       <a class="xref" href="storage-engines.html" title="Chapter 18 Alternative Storage Engines">
        Chapter 18,
        <i>
         Alternative Storage Engines
        </i>
       </a>
       .
      </p>
     </li>
     <li class="listitem">
      <p>
       Functional key parts (see
       <a class="xref" href="create-index.html" title="15.1.15 CREATE INDEX Statement">
        Section 15.1.15, “CREATE INDEX Statement”
       </a>
       )
              are implemented as hidden virtual generated stored
              columns, so each functional key part in a table index
              counts against the table total column limit.
      </p>
     </li>
    </ul>
   </div>
  </div>
  <div class="simplesect">
   <div class="titlepage">
    <div>
     <div class="simple">
      <h4 class="title">
       <a name="row-size-limits">
       </a>
       Row Size Limits
      </h4>
     </div>
    </div>
   </div>
   <a class="indexterm" name="idm46045226378592">
   </a>
   <a class="indexterm" name="idm46045226377104">
   </a>
   <a class="indexterm" name="idm46045226375616">
   </a>
   <p>
    The maximum row size for a given table is determined by
          several factors:
   </p>
   <div class="itemizedlist">
    <ul class="itemizedlist" style="list-style-type: disc; ">
     <li class="listitem">
      <p>
       The internal representation of a MySQL table has a maximum
              row size limit of 65,535 bytes, even if the storage engine
              is capable of supporting larger rows.
       <a class="link" href="blob.html" title="13.3.4 The BLOB and TEXT Types">
        <code class="literal">
         BLOB
        </code>
       </a>
       and
       <a class="link" href="blob.html" title="13.3.4 The BLOB and TEXT Types">
        <code class="literal">
         TEXT
        </code>
       </a>
       columns only
              contribute 9 to 12 bytes toward the row size limit because
              their contents are stored separately from the rest of the
              row.
      </p>
     </li>
     <li class="listitem">
      <p>
       The maximum row size for an
       <code class="literal">
        InnoDB
       </code>
       table, which applies to data stored locally within a
              database page, is slightly less than half a page for 4KB,
              8KB, 16KB, and 32KB
       <a class="link" href="innodb-parameters.html#sysvar_innodb_page_size">
        <code class="literal">
         innodb_page_size
        </code>
       </a>
       settings. For example, the maximum row size is slightly
              less than 8KB for the default 16KB
       <code class="literal">
        InnoDB
       </code>
       page size. For 64KB pages, the
              maximum row size is slightly less than 16KB. See
       <a class="xref" href="innodb-limits.html" title="17.21 InnoDB Limits">
        Section 17.21, “InnoDB Limits”
       </a>
       .
      </p>
      <p>
       If a row containing
       <a class="link" href="glossary.html#glos_variable_length_type" title="variable-length type">
        variable-length
              columns
       </a>
       exceeds the
       <code class="literal">
        InnoDB
       </code>
       maximum row size,
       <code class="literal">
        InnoDB
       </code>
       selects
              variable-length columns for external off-page storage
              until the row fits within the
       <code class="literal">
        InnoDB
       </code>
       row size limit. The amount of data stored locally for
              variable-length columns that are stored off-page differs
              by row format. For more information, see
       <a class="xref" href="innodb-row-format.html" title="17.10 InnoDB Row Formats">
        Section 17.10, “InnoDB Row Formats”
       </a>
       .
      </p>
     </li>
     <li class="listitem">
      <p>
       Different storage formats use different amounts of page
              header and trailer data, which affects the amount of
              storage available for rows.
      </p>
      <div class="itemizedlist">
       <ul class="itemizedlist" style="list-style-type: circle; ">
        <li class="listitem">
         <p>
          For information about
          <code class="literal">
           InnoDB
          </code>
          row
                  formats, see
          <a class="xref" href="innodb-row-format.html" title="17.10 InnoDB Row Formats">
           Section 17.10, “InnoDB Row Formats”
          </a>
          .
         </p>
        </li>
        <li class="listitem">
         <p>
          For information about
          <code class="literal">
           MyISAM
          </code>
          storage formats, see
          <a class="xref" href="myisam-table-formats.html" title="18.2.3 MyISAM Table Storage Formats">
           Section 18.2.3, “MyISAM Table Storage Formats”
          </a>
          .
         </p>
        </li>
       </ul>
      </div>
     </li>
    </ul>
   </div>
   <h5>
    <a name="idm46045226354528">
    </a>
    Row Size Limit Examples
   </h5>
   <div class="itemizedlist">
    <ul class="itemizedlist" style="list-style-type: disc; ">
     <li class="listitem">
      <p>
       The MySQL maximum row size limit of 65,535 bytes is
              demonstrated in the following
       <code class="literal">
        InnoDB
       </code>
       and
       <code class="literal">
        MyISAM
       </code>
       examples. The limit is
              enforced regardless of storage engine, even though the
              storage engine may be capable of supporting larger rows.
      </p>
      <div class="copytoclipboard-wrapper">
       <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa48880282"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-sql"><span class="token prompt">mysql&gt;</span> <span class="token keyword">CREATE</span> <span class="token keyword">TABLE</span> t <span class="token punctuation">(</span>a <span class="token datatype">VARCHAR</span><span class="token punctuation">(</span><span class="token number">10000</span><span class="token punctuation">)</span><span class="token punctuation">,</span> b <span class="token datatype">VARCHAR</span><span class="token punctuation">(</span><span class="token number">10000</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
       c <span class="token datatype">VARCHAR</span><span class="token punctuation">(</span><span class="token number">10000</span><span class="token punctuation">)</span><span class="token punctuation">,</span> d <span class="token datatype">VARCHAR</span><span class="token punctuation">(</span><span class="token number">10000</span><span class="token punctuation">)</span><span class="token punctuation">,</span> e <span class="token datatype">VARCHAR</span><span class="token punctuation">(</span><span class="token number">10000</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
       f <span class="token datatype">VARCHAR</span><span class="token punctuation">(</span><span class="token number">10000</span><span class="token punctuation">)</span><span class="token punctuation">,</span> g <span class="token datatype">VARCHAR</span><span class="token punctuation">(</span><span class="token number">6000</span><span class="token punctuation">)</span><span class="token punctuation">)</span> <span class="token keyword">ENGINE</span><span class="token operator">=</span>InnoDB <span class="token keyword">CHARACTER</span> <span class="token keyword">SET</span> latin1<span class="token punctuation">;</span>
<span class="token output">ERROR 1118 (42000)<span class="token punctuation">:</span> Row size too large. The maximum row size for the used
table type, not counting BLOBs, is 65535. This includes storage overhead,
check the manual. You have to change some columns to TEXT or BLOBs</span></code></pre>
      </div>
      <div class="copytoclipboard-wrapper">
       <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa28900191"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-sql"><span class="token prompt">mysql&gt;</span> <span class="token keyword">CREATE</span> <span class="token keyword">TABLE</span> t <span class="token punctuation">(</span>a <span class="token datatype">VARCHAR</span><span class="token punctuation">(</span><span class="token number">10000</span><span class="token punctuation">)</span><span class="token punctuation">,</span> b <span class="token datatype">VARCHAR</span><span class="token punctuation">(</span><span class="token number">10000</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
       c <span class="token datatype">VARCHAR</span><span class="token punctuation">(</span><span class="token number">10000</span><span class="token punctuation">)</span><span class="token punctuation">,</span> d <span class="token datatype">VARCHAR</span><span class="token punctuation">(</span><span class="token number">10000</span><span class="token punctuation">)</span><span class="token punctuation">,</span> e <span class="token datatype">VARCHAR</span><span class="token punctuation">(</span><span class="token number">10000</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
       f <span class="token datatype">VARCHAR</span><span class="token punctuation">(</span><span class="token number">10000</span><span class="token punctuation">)</span><span class="token punctuation">,</span> g <span class="token datatype">VARCHAR</span><span class="token punctuation">(</span><span class="token number">6000</span><span class="token punctuation">)</span><span class="token punctuation">)</span> <span class="token keyword">ENGINE</span><span class="token operator">=</span>MyISAM <span class="token keyword">CHARACTER</span> <span class="token keyword">SET</span> latin1<span class="token punctuation">;</span>
<span class="token output">ERROR 1118 (42000)<span class="token punctuation">:</span> Row size too large. The maximum row size for the used
table type, not counting BLOBs, is 65535. This includes storage overhead,
check the manual. You have to change some columns to TEXT or BLOBs</span></code></pre>
      </div>
      <p>
       In the following
       <code class="literal">
        MyISAM
       </code>
       example,
              changing a column to
       <a class="link" href="blob.html" title="13.3.4 The BLOB and TEXT Types">
        <code class="literal">
         TEXT
        </code>
       </a>
       avoids the 65,535-byte row size limit and permits the
              operation to succeed because
       <a class="link" href="blob.html" title="13.3.4 The BLOB and TEXT Types">
        <code class="literal">
         BLOB
        </code>
       </a>
       and
       <a class="link" href="blob.html" title="13.3.4 The BLOB and TEXT Types">
        <code class="literal">
         TEXT
        </code>
       </a>
       columns only
              contribute 9 to 12 bytes toward the row size.
      </p>
      <div class="copytoclipboard-wrapper">
       <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa70365292"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-sql"><span class="token prompt">mysql&gt;</span> <span class="token keyword">CREATE</span> <span class="token keyword">TABLE</span> t <span class="token punctuation">(</span>a <span class="token datatype">VARCHAR</span><span class="token punctuation">(</span><span class="token number">10000</span><span class="token punctuation">)</span><span class="token punctuation">,</span> b <span class="token datatype">VARCHAR</span><span class="token punctuation">(</span><span class="token number">10000</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
       c <span class="token datatype">VARCHAR</span><span class="token punctuation">(</span><span class="token number">10000</span><span class="token punctuation">)</span><span class="token punctuation">,</span> d <span class="token datatype">VARCHAR</span><span class="token punctuation">(</span><span class="token number">10000</span><span class="token punctuation">)</span><span class="token punctuation">,</span> e <span class="token datatype">VARCHAR</span><span class="token punctuation">(</span><span class="token number">10000</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
       f <span class="token datatype">VARCHAR</span><span class="token punctuation">(</span><span class="token number">10000</span><span class="token punctuation">)</span><span class="token punctuation">,</span> g <span class="token datatype">TEXT</span><span class="token punctuation">(</span><span class="token number">6000</span><span class="token punctuation">)</span><span class="token punctuation">)</span> <span class="token keyword">ENGINE</span><span class="token operator">=</span>MyISAM <span class="token keyword">CHARACTER</span> <span class="token keyword">SET</span> latin1<span class="token punctuation">;</span>
<span class="token output">Query OK, 0 rows affected (0.02 sec)</span></code></pre>
      </div>
      <p>
       The operation succeeds for an
       <code class="literal">
        InnoDB
       </code>
       table because changing a column to
       <a class="link" href="blob.html" title="13.3.4 The BLOB and TEXT Types">
        <code class="literal">
         TEXT
        </code>
       </a>
       avoids the MySQL
              65,535-byte row size limit, and
       <code class="literal">
        InnoDB
       </code>
       off-page storage of variable-length columns avoids the
       <code class="literal">
        InnoDB
       </code>
       row size limit.
      </p>
      <div class="copytoclipboard-wrapper">
       <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa48947448"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-sql"><span class="token prompt">mysql&gt;</span> <span class="token keyword">CREATE</span> <span class="token keyword">TABLE</span> t <span class="token punctuation">(</span>a <span class="token datatype">VARCHAR</span><span class="token punctuation">(</span><span class="token number">10000</span><span class="token punctuation">)</span><span class="token punctuation">,</span> b <span class="token datatype">VARCHAR</span><span class="token punctuation">(</span><span class="token number">10000</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
       c <span class="token datatype">VARCHAR</span><span class="token punctuation">(</span><span class="token number">10000</span><span class="token punctuation">)</span><span class="token punctuation">,</span> d <span class="token datatype">VARCHAR</span><span class="token punctuation">(</span><span class="token number">10000</span><span class="token punctuation">)</span><span class="token punctuation">,</span> e <span class="token datatype">VARCHAR</span><span class="token punctuation">(</span><span class="token number">10000</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
       f <span class="token datatype">VARCHAR</span><span class="token punctuation">(</span><span class="token number">10000</span><span class="token punctuation">)</span><span class="token punctuation">,</span> g <span class="token datatype">TEXT</span><span class="token punctuation">(</span><span class="token number">6000</span><span class="token punctuation">)</span><span class="token punctuation">)</span> <span class="token keyword">ENGINE</span><span class="token operator">=</span>InnoDB <span class="token keyword">CHARACTER</span> <span class="token keyword">SET</span> latin1<span class="token punctuation">;</span>
<span class="token output">Query OK, 0 rows affected (0.02 sec)</span></code></pre>
      </div>
     </li>
     <li class="listitem">
      <p>
       Storage for variable-length columns includes length bytes,
              which are counted toward the row size. For example, a
       <a class="link" href="char.html" title="13.3.2 The CHAR and VARCHAR Types">
        <code class="literal">
         VARCHAR(255)
              CHARACTER SET utf8mb3
        </code>
       </a>
       column takes two bytes to
              store the length of the value, so each value can take up
              to 767 bytes.
      </p>
      <p>
       The statement to create table
       <code class="literal">
        t1
       </code>
       succeeds because the columns require 32,765 + 2 bytes and
              32,766 + 2 bytes, which falls within the maximum row size
              of 65,535 bytes:
      </p>
      <div class="copytoclipboard-wrapper">
       <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa39838191"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-sql"><span class="token prompt">mysql&gt;</span> <span class="token keyword">CREATE</span> <span class="token keyword">TABLE</span> t1
       <span class="token punctuation">(</span>c1 <span class="token datatype">VARCHAR</span><span class="token punctuation">(</span><span class="token number">32765</span><span class="token punctuation">)</span> <span class="token operator">NOT</span> <span class="token boolean">NULL</span><span class="token punctuation">,</span> c2 <span class="token datatype">VARCHAR</span><span class="token punctuation">(</span><span class="token number">32766</span><span class="token punctuation">)</span> <span class="token operator">NOT</span> <span class="token boolean">NULL</span><span class="token punctuation">)</span>
       <span class="token keyword">ENGINE</span> <span class="token operator">=</span> InnoDB <span class="token keyword">CHARACTER</span> <span class="token keyword">SET</span> latin1<span class="token punctuation">;</span>
<span class="token output">Query OK, 0 rows affected (0.02 sec)</span></code></pre>
      </div>
      <p>
       The statement to create table
       <code class="literal">
        t2
       </code>
       fails
              because, although the column length is within the maximum
              length of 65,535 bytes, two additional bytes are required
              to record the length, which causes the row size to exceed
              65,535 bytes:
      </p>
      <div class="copytoclipboard-wrapper">
       <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa59029670"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-sql"><span class="token prompt">mysql&gt;</span> <span class="token keyword">CREATE</span> <span class="token keyword">TABLE</span> t2
       <span class="token punctuation">(</span>c1 <span class="token datatype">VARCHAR</span><span class="token punctuation">(</span><span class="token number">65535</span><span class="token punctuation">)</span> <span class="token operator">NOT</span> <span class="token boolean">NULL</span><span class="token punctuation">)</span>
       <span class="token keyword">ENGINE</span> <span class="token operator">=</span> InnoDB <span class="token keyword">CHARACTER</span> <span class="token keyword">SET</span> latin1<span class="token punctuation">;</span>
<span class="token output">ERROR 1118 (42000)<span class="token punctuation">:</span> Row size too large. The maximum row size for the used
table type, not counting BLOBs, is 65535. This includes storage overhead,
check the manual. You have to change some columns to TEXT or BLOBs</span></code></pre>
      </div>
      <p>
       Reducing the column length to 65,533 or less permits the
              statement to succeed.
      </p>
      <div class="copytoclipboard-wrapper">
       <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa61986750"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-sql"><span class="token prompt">mysql&gt;</span> <span class="token keyword">CREATE</span> <span class="token keyword">TABLE</span> t2
       <span class="token punctuation">(</span>c1 <span class="token datatype">VARCHAR</span><span class="token punctuation">(</span><span class="token number">65533</span><span class="token punctuation">)</span> <span class="token operator">NOT</span> <span class="token boolean">NULL</span><span class="token punctuation">)</span>
       <span class="token keyword">ENGINE</span> <span class="token operator">=</span> InnoDB <span class="token keyword">CHARACTER</span> <span class="token keyword">SET</span> latin1<span class="token punctuation">;</span>
<span class="token output">Query OK, 0 rows affected (0.01 sec)</span></code></pre>
      </div>
     </li>
     <li class="listitem">
      <p>
       For
       <a class="link" href="myisam-storage-engine.html" title="18.2 The MyISAM Storage Engine">
        <code class="literal">
         MyISAM
        </code>
       </a>
       tables,
       <code class="literal">
        NULL
       </code>
       columns require additional space
              in the row to record whether their values are
       <code class="literal">
        NULL
       </code>
       . Each
       <code class="literal">
        NULL
       </code>
       column takes one bit extra, rounded up to the nearest
              byte.
      </p>
      <p>
       The statement to create table
       <code class="literal">
        t3
       </code>
       fails
              because
       <a class="link" href="myisam-storage-engine.html" title="18.2 The MyISAM Storage Engine">
        <code class="literal">
         MyISAM
        </code>
       </a>
       requires space
              for
       <code class="literal">
        NULL
       </code>
       columns in addition to the
              space required for variable-length column length bytes,
              causing the row size to exceed 65,535 bytes:
      </p>
      <div class="copytoclipboard-wrapper">
       <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa95072317"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-sql"><span class="token prompt">mysql&gt;</span> <span class="token keyword">CREATE</span> <span class="token keyword">TABLE</span> t3
       <span class="token punctuation">(</span>c1 <span class="token datatype">VARCHAR</span><span class="token punctuation">(</span><span class="token number">32765</span><span class="token punctuation">)</span> <span class="token boolean">NULL</span><span class="token punctuation">,</span> c2 <span class="token datatype">VARCHAR</span><span class="token punctuation">(</span><span class="token number">32766</span><span class="token punctuation">)</span> <span class="token boolean">NULL</span><span class="token punctuation">)</span>
       <span class="token keyword">ENGINE</span> <span class="token operator">=</span> MyISAM <span class="token keyword">CHARACTER</span> <span class="token keyword">SET</span> latin1<span class="token punctuation">;</span>
<span class="token output">ERROR 1118 (42000)<span class="token punctuation">:</span> Row size too large. The maximum row size for the used
table type, not counting BLOBs, is 65535. This includes storage overhead,
check the manual. You have to change some columns to TEXT or BLOBs</span></code></pre>
      </div>
      <p>
       For information about
       <a class="link" href="innodb-storage-engine.html" title="Chapter 17 The InnoDB Storage Engine">
        <code class="literal">
         InnoDB
        </code>
       </a>
       <code class="literal">
        NULL
       </code>
       column storage, see
       <a class="xref" href="innodb-row-format.html" title="17.10 InnoDB Row Formats">
        Section 17.10, “InnoDB Row Formats”
       </a>
       .
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        InnoDB
       </code>
       restricts row size (for data
              stored locally within the database page) to slightly less
              than half a database page for 4KB, 8KB, 16KB, and 32KB
       <a class="link" href="innodb-parameters.html#sysvar_innodb_page_size">
        <code class="literal">
         innodb_page_size
        </code>
       </a>
       settings, and to slightly less than 16KB for 64KB pages.
      </p>
      <p>
       The statement to create table
       <code class="literal">
        t4
       </code>
       fails
              because the defined columns exceed the row size limit for
              a 16KB
       <code class="literal">
        InnoDB
       </code>
       page.
      </p>
      <div class="copytoclipboard-wrapper">
       <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa52425944"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-sql"><span class="token prompt">mysql&gt;</span> <span class="token keyword">CREATE</span> <span class="token keyword">TABLE</span> t4 <span class="token punctuation">(</span>
       c1 <span class="token datatype">CHAR</span><span class="token punctuation">(</span><span class="token number">255</span><span class="token punctuation">)</span><span class="token punctuation">,</span>c2 <span class="token datatype">CHAR</span><span class="token punctuation">(</span><span class="token number">255</span><span class="token punctuation">)</span><span class="token punctuation">,</span>c3 <span class="token datatype">CHAR</span><span class="token punctuation">(</span><span class="token number">255</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
       c4 <span class="token datatype">CHAR</span><span class="token punctuation">(</span><span class="token number">255</span><span class="token punctuation">)</span><span class="token punctuation">,</span>c5 <span class="token datatype">CHAR</span><span class="token punctuation">(</span><span class="token number">255</span><span class="token punctuation">)</span><span class="token punctuation">,</span>c6 <span class="token datatype">CHAR</span><span class="token punctuation">(</span><span class="token number">255</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
       c7 <span class="token datatype">CHAR</span><span class="token punctuation">(</span><span class="token number">255</span><span class="token punctuation">)</span><span class="token punctuation">,</span>c8 <span class="token datatype">CHAR</span><span class="token punctuation">(</span><span class="token number">255</span><span class="token punctuation">)</span><span class="token punctuation">,</span>c9 <span class="token datatype">CHAR</span><span class="token punctuation">(</span><span class="token number">255</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
       c10 <span class="token datatype">CHAR</span><span class="token punctuation">(</span><span class="token number">255</span><span class="token punctuation">)</span><span class="token punctuation">,</span>c11 <span class="token datatype">CHAR</span><span class="token punctuation">(</span><span class="token number">255</span><span class="token punctuation">)</span><span class="token punctuation">,</span>c12 <span class="token datatype">CHAR</span><span class="token punctuation">(</span><span class="token number">255</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
       c13 <span class="token datatype">CHAR</span><span class="token punctuation">(</span><span class="token number">255</span><span class="token punctuation">)</span><span class="token punctuation">,</span>c14 <span class="token datatype">CHAR</span><span class="token punctuation">(</span><span class="token number">255</span><span class="token punctuation">)</span><span class="token punctuation">,</span>c15 <span class="token datatype">CHAR</span><span class="token punctuation">(</span><span class="token number">255</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
       c16 <span class="token datatype">CHAR</span><span class="token punctuation">(</span><span class="token number">255</span><span class="token punctuation">)</span><span class="token punctuation">,</span>c17 <span class="token datatype">CHAR</span><span class="token punctuation">(</span><span class="token number">255</span><span class="token punctuation">)</span><span class="token punctuation">,</span>c18 <span class="token datatype">CHAR</span><span class="token punctuation">(</span><span class="token number">255</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
       c19 <span class="token datatype">CHAR</span><span class="token punctuation">(</span><span class="token number">255</span><span class="token punctuation">)</span><span class="token punctuation">,</span>c20 <span class="token datatype">CHAR</span><span class="token punctuation">(</span><span class="token number">255</span><span class="token punctuation">)</span><span class="token punctuation">,</span>c21 <span class="token datatype">CHAR</span><span class="token punctuation">(</span><span class="token number">255</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
       c22 <span class="token datatype">CHAR</span><span class="token punctuation">(</span><span class="token number">255</span><span class="token punctuation">)</span><span class="token punctuation">,</span>c23 <span class="token datatype">CHAR</span><span class="token punctuation">(</span><span class="token number">255</span><span class="token punctuation">)</span><span class="token punctuation">,</span>c24 <span class="token datatype">CHAR</span><span class="token punctuation">(</span><span class="token number">255</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
       c25 <span class="token datatype">CHAR</span><span class="token punctuation">(</span><span class="token number">255</span><span class="token punctuation">)</span><span class="token punctuation">,</span>c26 <span class="token datatype">CHAR</span><span class="token punctuation">(</span><span class="token number">255</span><span class="token punctuation">)</span><span class="token punctuation">,</span>c27 <span class="token datatype">CHAR</span><span class="token punctuation">(</span><span class="token number">255</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
       c28 <span class="token datatype">CHAR</span><span class="token punctuation">(</span><span class="token number">255</span><span class="token punctuation">)</span><span class="token punctuation">,</span>c29 <span class="token datatype">CHAR</span><span class="token punctuation">(</span><span class="token number">255</span><span class="token punctuation">)</span><span class="token punctuation">,</span>c30 <span class="token datatype">CHAR</span><span class="token punctuation">(</span><span class="token number">255</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
       c31 <span class="token datatype">CHAR</span><span class="token punctuation">(</span><span class="token number">255</span><span class="token punctuation">)</span><span class="token punctuation">,</span>c32 <span class="token datatype">CHAR</span><span class="token punctuation">(</span><span class="token number">255</span><span class="token punctuation">)</span><span class="token punctuation">,</span>c33 <span class="token datatype">CHAR</span><span class="token punctuation">(</span><span class="token number">255</span><span class="token punctuation">)</span>
       <span class="token punctuation">)</span> <span class="token keyword">ENGINE</span><span class="token operator">=</span>InnoDB <span class="token keyword">ROW_FORMAT</span><span class="token operator">=</span><span class="token keyword">DYNAMIC</span> <span class="token keyword">DEFAULT</span> <span class="token keyword">CHARSET</span> latin1<span class="token punctuation">;</span>
<span class="token output">ERROR 1118 (42000)<span class="token punctuation">:</span> Row size too large (&gt; 8126). Changing some columns to TEXT or BLOB may help.
In current row format, BLOB prefix of 0 bytes is stored inline.</span></code></pre>
      </div>
     </li>
    </ul>
   </div>
  </div>
 </div>
 <br/>
</div>
