My memory could be failing me, but I seem to recall storing 65K characters in a TEXT column.
(from the manual) TINYBLOB, TINYTEXT - A BLOB or TEXT column with a maximum length of 255 (2^8 - 1) characters. BLOB, TEXT - A BLOB or TEXT column with a maximum length of 65535 (2^16 - 1) characters. MEDIUMBLOB MEDIUMTEXT - A BLOB or TEXT column with a maximum length of 16777215 (2^24 - 1) characters. LONGBLOB LONGTEXT - A BLOB or TEXT column with a maximum length of 4294967295 (2^32 - 1) characters. Have you checked your form for the potential truncation? I suspect there is a default maximum for type=Text input controls. Textarea works better, but you need to filter for printable characters as some control characters in the data will cause presentation problems. I also have experienced one instance of truncation because I forgot to use method=post. There is a limit on URL Lengths. hope this gives you a few places to look. Warren Vail [EMAIL PROTECTED] -----Original Message----- From: Bobo Wieland [mailto:[EMAIL PROTECTED]] Sent: Friday, January 10, 2003 3:15 AM To: [EMAIL PROTECTED] Subject: [PHP-WIN] TEXT (again) Sorry about this. My mailserver hates me ;) Hi everybody! I'm new to this list and joind because I ran in to some trouble last night... I'm developing a medium sized web site where you should be able to post questions and get them answered, sort of a faq. Anyway - both the question field and the anwser field are stored as TEXT in a MySQL db. When these fields get larger then just your average question it mocks up my php-scripts real bad. As I've understood there is some values in the php.ini that might do the trick - but I would prefer not to change these. And besides, I don't think that the the fields have been that big when I tried it so that it would run in to these limits. Anyway to explain my problem a bit more; I did some stupid things when I first started to script the page. I did three variables $xhtmlstart, $xhtmlend and $xhtmlmenu. The first and second explains them selfe, right? But the last is a menu where you can choose questions. It shows the last ten questions in all categories, and there can be n categories... The reason I made these three variables is that I thought that it might be faster to do de db work once and then just display the variable. I haven't been in to php that long so I'm learning as I go... I've been pasing these three variables as POST-variables that I rawurldecoded... maybe I should use session variables or just do the db work over and over again?! Anyway, when choosing a question that has loads of text put in to it, IE tries to reload the page several times and eventually stops only displaying the accual new xhtml-code I've echoed out on that page, skipping the POST, variables and skipping the questions output. In Mozilla it works as it should most of the tim and in Opera 6 and 7 it starts out okej but the script aborts half-way through only displaying $xhtmlstart and 2/3 of the big question... Could you give me some hint on this one? What to do with the variables, and how to work around the problem with large amount of data? There isn't some MySQL type that goes in between VARCHAR/TINYTEXT and TEXT, right? If it helps I'm using Win XP, Apache 2.0.40, PHP 4.0.4, MySQL 4.0.3-beta and I echo out my pages to work with the XHTML standard... - Bobo Wieland, Sweden. [EMAIL PROTECTED] www.elstudion.com www.elstudion.com/bobo -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
