[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.
HTH,
RonL.
More information about the thelist
mailing list