Re: BLOB, SUBSTRING and 65536 characters limit

2004-03-12 Thread Tomas Zvala
I'm sorry, the problem was of course between keyboard and chair. I didn't realize I'm using BLOB which is limited to 65536 characters insted of longblob that is quite larger. Thanks for your answers. Tomas Tomas Zvala wrote: Hello, I run into a problem where I need to get contents of BLOB to

BLOB, SUBSTRING and 65536 characters limit

2004-03-11 Thread Tomas Zvala
Hello, I run into a problem where I need to get contents of BLOB to my php script. I found out that I'm limited by max_packet_size (which i can't change because of my ISP) and i tried to work around it by using SELECT substring(column,x,1024) where x is number increasing in steps of 1024. But

Re: BLOB, SUBSTRING and 65536 characters limit

2004-03-11 Thread colbey
http://php.dreamwerx.net/forums/viewtopic.php?t=6 storage implementation that is not affected by max_packet_size. On Thu, 11 Mar 2004, Tomas Zvala wrote: Hello, I run into a problem where I need to get contents of BLOB to my php script. I found out that I'm limited by max_packet_size