MySQL data type: Text,,, Erroring: Data Too Long

mysql coldfusion types
AnApprentice picture AnApprentice · Apr 3, 2010 · Viewed 19.5k times · Source

I have a field as follows in MySQL: Type: Text Length: 0 Decimals: 0

And when I try to insert data around the size of 4 pages of MS Word, Coldfusion errors with: Data Too Long from the DB.

I thought TEXT data type was able to expand and handle this size of data? What am I missing and what can I do?

Answer

Mark Byers picture Mark Byers · Apr 3, 2010

The type TEXT is limited to 2^16 bytes, or 65536 bytes. Try using the type LONGTEXT instead. It can hold values up to 2^32 bytes in length.

Related questions

Is there a way to 'listen' for a database event and update a page in real time?

I'm looking for a way to create a simple HTML table that can be updated in real-time upon a database change event; specifically a new record added. In other words, think of it like an executive dashboard. If a sale …

Read More
Get table ID after insert with ColdFusion and MySQL

My normal process for inserting into one table and then getting the ID back so that I can insert into another table is like this in MSSQL: DECLARE @transactionKey uniqueidentifier SET @transactionKey = NEWID() INSERT INTO transactions(transactionKey, transactionDate, transactionAmount) VALUES(@…

Read More
How do I import an SQL file using the command line in MySQL?

I have a .sql file with an export from phpMyAdmin. I want to import it into a different server using the command line. I have a Windows Server 2008 R2 installation. I placed the .sql file on the C drive, and …

Read More