Breaking News: Grepper is joining You.com. Read the official announcement!
Check it out

#1709 - Index column size too large. The maximum column size is 767 bytes

Exuberant Echidna answered on January 23, 2023 Popularity 6/10 Helpfulness 3/10

Contents


More Related Answers

  • row size too large ( 8126)
  • Erreur SQL sur la requête Index column size too large. The maximum column size is 767 bytes.
  • #1118 - Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.
  • #1118 - Row size too large (> 8126)
  • Row size too large (> 8126)
  • #1118 - Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.
  • Row size too large (> 8126)
  • index column size too large. the maximum column size is 767 bytes. mysql
  • mysql error the maximum column size is 767 bytes.
  • #1118 - Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.
  • 1118 - Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs
  • The maximum column size is 767 bytes.
  • #1709 - Index column size too large

  • #1709 - Index column size too large. The maximum column size is 767 bytes

    0
    Popularity 6/10 Helpfulness 3/10 Language whatever
    Tags: size whatever
    Link to this answer
    Share Copy Link
    Contributed on Feb 08 2023
    Exuberant Echidna
    0 Answers  Avg Quality 2/10

    Closely Related Answers



    1
    Popularity 9/10 Helpfulness 10/10 Language whatever
    Source: Grepper
    Link to this answer
    Share Copy Link
    Contributed on Jan 23 2023
    Exuberant Echidna
    0 Answers  Avg Quality 2/10

    1

    my.ini Change the config for innodb-default-row-format value

    from innodb-default-row-format=compact

    to innodb-default-row-format=dynamic

    Restart mysql 

    Popularity 7/10 Helpfulness 5/10 Language whatever
    Source: Grepper
    Tags: size whatever
    Link to this answer
    Share Copy Link
    Contributed on Mar 21 2023
    Prabhugoud Patil
    0 Answers  Avg Quality 2/10


    X

    Continue with Google

    By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.
    X
    Grepper Account Login Required

    Oops, You will need to install Grepper and log-in to perform this action.