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.



  • mdadm frozen and doesn't realize array is dead/missing failed due to unplugged drives
  • Unable to mount location Failed to retrieve share list from server: No such file or directory solution
  • mdadm how to make inactive array active
  • ImageMagick how to trim white space automatically in Linux
  • curl: (1) Protocol "https not supported or disabled in libcurl"
  • Centos 5 OpenSSL does not support TLS 1.2 Apache Error
  • DRBD Split-brain solution
  • How to Properly Secure SSL/TLS Apache Settings against Heartbleed Poodle (TLS) Poodle (SSLv3) FREAK BEAST CRIME
  • K9 Mail Android Cannot See or View E-mails Disappear after reading - with Dovecot server. Solution
  • The folder contents could not be displayed connection refused - solution
  • Setting Up System for First Use... Please Wait... - WHMCS Installer
  • ERROR 2013 (HY000): Lost connection to MySQL server during query
  • if script bash check if socket file (mysql.sock) exists
  • ioncube loader install howto on PHP/Centos
  • apc_shm_attach: shmat failed: in Unknown on line 0 & apc_shm_create: shmget(0, 67108864, 914) failed PHP Solution
  • MySQLD Server shutdown remotely unexpectedly
  • cPanel Install Error kernel ipv6 module support solution
  • bash count length of string and characters
  • PayPal Subscription Howto Creation Automatic Payments Manual
  • bind/named rndc: connect failed: 127.0.0.1#953: connection refused (solution)