/ Web Hosting - rtt - IT Resource

Web Hosting

  • MySQL TEXT field size length limit reminder, don't truncate your data!


    I thought there would be an error message or warning from MySQL in the case that the text you submit is greater than the allowed limit based on the field.

    So essentially I submitted text that was about 120,000 characters long, whereas the limit of TEXT is just 65,535 characters!  I almost lost half of my data/what I typed without knowing it!

    I just altered the field type in my database from TEXT to LONGTEXT.  I can't see how LONGTEXT wouldn't be long enough for MOST users and uses, which is basically 400 Million characters long.

    Or if you want the middle ground choose MEDIUMTEXT at a length of 16 Million characters.

    This is really something not to overlook, especially if you are entering a lot of text/copying and pasting server logs etc..

    Here are the different limits of the MySQL text fields:

    TINYTEXT
       
        A BLOB or TEXT column with a maximum length of 255 (2^8 - 1) characters


    TEXT
       
        A BLOB or TEXT column with a maximum length of 65535 (2^16 - 1) characters

    MEDIUMTEXT
       
        A BLOB or TEXT column with a maximum length of 16777215 (2^24 - 1) characters


    LONGTEXT
       
        A BLOB or TEXT column with a maximum length of 4294967295 (2^32 - 1) characters


  • VBulletin How To Change Welcome E-mail


    Login as Admin

    Languages & Phrases -> Search in Phrases

    Choose "Phrase Variable Name Only"

    Search for: welcomemail

    Edit the "Translation" box with what you'd like in it.


  • Latest Articles

  • syntax error, unexpected T_SL in PHP Solution
  • grep regular expression match number range between specific numbers
  • bash how to print out lines of text within a range from the first occurrence
  • bash script how to to check LAN computers for open ports
  • MySQL Using mytop Debug Source of High IO and Slow Performance
  • How To Mathematically Convert and Calculate Binary Value To Decimal Value
  • systemd management using systemctl and journalctl to check systemd logs
  • css how to format code in the code tag
  • css br with extra blank line
  • What is /dev/pts and why do we need it in Linux?
  • Linux What is umask (user mask) for file and directory creation permissions and how to calculate umask and change the defaults
  • Linux Permissions and Groups Real Usecase for Group Access
  • Centos 7 python34 how to install the gi library
  • Centos 7 - Convert Minimal to Graphical GUI GNOME or KDE Desktop
  • AMD Set Fan Speed and Other Powerplay Memory/CPU Timings with a Linux script
  • Ethereum Mining Claymore Nanopool Error
  • genisoimage errors with long filenames and deep directory structures
  • Linux Kernel USB Export Errors
  • How to download gajim 0.16.9 XMPP/Jabber client so you can use OMEMO encryption
  • HP DL385 G7 Linux BIOS Update Flash