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

[Luther, Ron]

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.



HTH,

RonL.