Justin French <mailto:[EMAIL PROTECTED]> on Monday, December 22, 2003 6:12 PM said:
Sounds more like the mysql field is a varchar255, rather than maybe a mediumtext, and only the first 255 chars are getting inserted into the DB?
But I could be horribly wrong :)
In an effort to keep this thread going and hopefully find an answer op left out some important information this time around. (He posted a related question yesterday.)
He is not using MySQL. He is using MSSQL. According to what he said in another thread the database has stored all the data without being cutoff. I imagine he's able to view it in another way aside from retrieving it via php to verify it's been inserted completely.
Does this help anyone narrow it down? (because I certainly have no idea.)
This problem comes up every now and then, but I can't find anything good in the archives. Basically, if you're using a varchar (or nvarchar?) column, you can only have a max size of 255 characters. Anything larger needs to use a text column. I think this is dependent upon the library you're using to access MSSQL (like an ODBC limitation?), so you should look at other libraries to see if this was fixed.
-- ---John Holmes...
Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/
php|architect: The Magazine for PHP Professionals – www.phparch.com
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
