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


Tags:

mysql, text, length, reminder, truncate, submit, essentially, submitted, characters, whereas, typed, altered, database, longtext, wouldn, users, mediumtext, overlook, copying, pasting, server, logs, etc, fields, tinytext, blob, column, maximum,

Latest Articles

  • Cisco Switches How To Get Of Port Line Status Console Messages
  • Cisco DHCP Snooping Relay Setup Information
  • Cisco Switch Setup Guide Command List
  • Cisco 2960 Switch Reset To Factory Defaults
  • How To Boot Cisco CUCM UCSInstall 8.6, 10, 11 and 12 on KVM/Proxmox
  • VBOX VirtualBox How To Import Raw .img Disk File
  • Windows Server 2012, 2016, 2019 How To Install and Missing Disabled Telnet Client
  • proxmox vm networking breaks when you restart your network on the hostnode
  • Linux ln symlink how to update existing symbolic link
  • Ubuntu 18.04 / Linux Mint 19.1 Cannot Type or Login - solution
  • LUKS Hard Drive Encryption on Linux Mint Ubuntu Debian etc how to mount encrypted hard drive
  • How to use nmap locate other machines/computers/servers on your network using nmap
  • Linux Mint 18.2 Create Config File To Start Application Upon Login
  • Dell Wyse Thin Client BIOS Access Key
  • sudoers file in /etc warning about comments/includes!
  • Centos 7 Reallocate logical volume space to another
  • lvm how to reduce volume size
  • letsencrypt certbot error "Unable to find a virtual host listening on port 80 which is currently needed for Certbot to prove to the CA that you control your domain. Please add a virtual host for port 80."
  • SSH error cannot Forward or Listen "bind: Cannot assign requested address"
  • X11 SSH Linux Forwarding Error