Re: [PHP] Re: Very Large MySQL Query String

2002-05-07 Thread David Bouw
Dear Javier, Yes, indeed when you encode the file it grows. Normally about 30%.. Thus, the file in my situation of 1 Megabyte grows to 1.3 MegaByte.. But I would expect that this should not give any problems... The columns I am using allows 16 Megabyte.. Does anyone else know what the string

[PHP] Re: Very Large MySQL Query String

2002-05-06 Thread Julio Nobrega Trabalhando
Instead of uploading to Mysql, why don't you store the file at a directory and on Mysql only the path to it? Retrieving files from the hard drive is much faster than doing the same on Mysql, and also access to manipulation (insert, update, delete, etc...) -- Julio Nobrega. Um dia eu chego

[PHP] Re: Very Large MySQL Query String

2002-05-06 Thread Kirk Babb
If I use the link to the file, i.e. file//C:\filedir\file.pdf or .txt or whatever how do I insert/update/delete the file since MySQL is holding only the link? BTW David, what are the properties of the field you are inserting to? Could that be the problem? -Kirk Julio Nobrega

Re: [PHP] Re: Very Large MySQL Query String

2002-05-06 Thread David Bouw
Dear Kirk (and Julio) Thanks for the response.. I don't want to use a link to the images because backing up my data and porting it to another machine is much easier. (Replicating is also very easy.) When storing the file separately this gets more complex, especially when you want to get this

Re: [PHP] Re: Very Large MySQL Query String

2002-05-06 Thread Javier
Hi, I think if you encode the file with base64 and store it in the database the size of the document will be more than 1MB sure. David Bouw wrote: Dear Kirk (and Julio) Thanks for the response.. I don't want to use a link to the images because backing up my data and porting it to another