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.



  • Linux How To Clone One System Harddrive to another remote system
  • Ubuntu/Debian/Linux won't boot and drops to Busybox shell after cloning HDD with dd
  • Unable to negotiate with 192.168.1.99 port 22: no matching host key type found. Their offer: ssh-dss Solution
  • Centos 7 Password Reset
  • MySQL Adding New Field to Existing Database Table
  • MySQL Cannot Update/Write to any database table solution
  • Centos How To Update to Glibc 2.14 Plus
  • php remove last letters of string
  • MySQL Maximum INT Size Truncation Issue/Warning
  • MySQL How To Add New Field Column To Existing Table
  • mysql how to reset passwords with a few commands
  • htaccess apache how deny/allow to block or allow by IP address
  • PHP geoip.so fatal error Solution
  • Syntax error on line 221 of /etc/httpd/conf/httpd.conf: Syntax error on line 6 of /etc/httpd/conf.d/php.conf: Cannot load /etc/httpd/modules/libphp5.so into server: /etc/httpd/modules/libphp5.so: cannot open shared object file: No such file or direct
  • GCC 5 on Centos 6 - How To Install
  • bash find line and replace howto
  • How To Create Apache htpasswd file
  • possible SYN flooding on ctid 42131, port 80. Sending cookies. - Solution
  • Linux last command show login by IP instead of hostname
  • Install Windows From a Linux TFTP Server instead of using WDS Solution