Web Hosting -

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.



  • zip warning: name not matched: in Linux Solution
  • ls in Linux with full directory path with files howto
  • bash how to check if a symlink exists as a file or directory
  • css .ul and .li how to remove the identation padding/margin from list items?
  • how to extract .xz file in Linux Centos/Debian/Ubuntu
  • Linux how to whois query other gTLDs such as .club solution
  • How to verify SSL SHA-1 Certificate Fingerprnit Signature of your mail/web server to avoid hijacking/man-in-the-middle attacks
  • Linux Ubuntu Mint how to view RAW image files .arw?
  • ecryptfs errors
  • What happens when you unplug 1 or more devices from an mdadm RAID array to simulate a failure in Linux Ubuntu/Centos/Debian?
  • Migrating from Linux Mint 17.2 mdadm RAID array to a new one (because I upgraded to larger drives).
  • Linux how to reformat html file code solution
  • ENOM how to do a 301 redirect to another domain/site
  • ENOM TRANSFER passwords do not match - solution
  • Linux how to check http headers using bash/curl for SEO
  • mdadm: CREATE group disk not found Incrementally started RAID arrays. Incrementally starting RAID arrays...
  • Linux SAMBA does not work with symlinks
  • How to Execute PHP in .html files with Apache in Linux Centos/Debian/Ubuntu etc
  • mdadm how to recover from failed drive
  • yum Packages skipped because of dependency problems: