[thelist] SQL Insert via PHP (long text problem)

Luther, Ron Ron.Luther at hp.com
Fri Sep 22 16:20:13 CDT 2006

Duarte Pyrrait asked:

>>I'm having trouble inserting a long text into a field of a data table.
>>If  the text is too long, the insert statement don't work.
>>I think the maximum size for text is 8000 characters but the MySQL database 
>>don't accept a 3000 characters text.

Hi Duarte,

My guess is that this part is your clue:

>>The problem only happens at the client remote server. 
>>I´ve tryed in my local server and everything works as supposed.

How are you getting the data from the client to the server? 

IIRC a 'get' request may truncate before the 8000 character field limit.

Maybe run a check on what the server is receiving from the client.



More information about the thelist mailing list