Live chat Whatsapp
Live chat Whatsapp
Attiva Web - Realizzazione siti internet, ecommerce

Maximum number of characters per varchar field mysql

    • First let's see what a varchar is.

      Varchar in MySQL is a data type used to store text whose length is not fixed.

      The varchar columns in the table are variable-length strings that can contain numbers, characters, or both. This type of data was able to store only 255 characters before version 5.0.3, but with this version, we are talking about 5.8 and later it can contain up to 65535 characters.

      The total column must not exceed 65535 bytes.

      An important note, from experience I can say that in terms of reading speed a varchar field makes queries faster than a text field, so when you can always use varchar.

      Francesco // 09-03-2021 // MySQL

    Lascia un commento

    Invia commento


    ATTENZIONE: il tuo commento verrà prima moderato e se ritenuto idoneo sarà pubblicato