Hey all,
I have a client that uses phpMyAdmin quite a bit as sort of an end user type app, but that's another story altogether (they actually get a lot of use out of it when they're PHP app won't give them the data the way they want.)
But anyway, they've created a table with 9 fields type 'TEXT' and put about a paragraph or two into each field, but seemed to have run up against a limit there.
I'm pretty surprised that phpMyAdmin would have that kind of a limit there, and have checked out the data for any funkiness that might prevent it from displaying, but when they select that table to edit a record it displays only the top like describing the table and then stops.
Has anyone experienced anything like this with phpMyAdmin? They are running 2.5.7. I know they should upgrade and I keep telling them that, but they are one these "if it ain't broke don't fix it " outfits and have been using the same install for a couple of years, and are pretty set in their ways.
Thanks!
Skip
-- Skip Evans
Big Sky Penguin, LLC
61 W Broadway
Butte, Montana 59701
406-782-2240
http://bigskypenguin.com
=-=-=-=-=-=-=-=-=-=
Check out PHPenguin, a lightweight and
versatile PHP/MySQL development framework.
http://phpenguin.bigskypenguin.com/
MySQL TEXT fields have a limit of 65,000 bytes. If you insert anything larger than that in to a normal TEXT field mySQL will silently truncate your data without telling you (meaning software checks are probably a good idea). MEDIUMTEXT will store 16 million characters and LONGTEXT can handle over 4 trillion. Check the mysql docs for exact info, but this should help in general. The user should be able to change the field type without loosing their data.
Jake