Hi Guys,
Question: Is there a limit to the size of an image that can be loaded into mysql with PHP? I know, I know, but its not my decision to do this. The powers that be are rather close minded about this.
I have heard there is a 64k limit to a single variable and obviously a 64K variable can't hold a 1.5M image, can it?
The goal of this little task is copy certain rows of data from a remote host DB to a local system (and eventually to re-sync the host db).
Please let me know your thoughts...
TIA
image to db problem
Moderator: General Moderators
'BLOB' type can only hold 64K, 'MEDIUMBLOB' type can only hold 1.6 MB, but 'LONGBLOB' can hold 4.2 GB - so that should be big enough to hold anything you want.MySQL table sizesare kind of limited too.
Real programmers don't comment their code. If it was hard to write, it should be hard to understand.
I don't think there's a MySQL limit to the size of the data in a particular field beyond those restricted by the column type. I've got fields with over 300K and there's no problem. Like I said, LONGBLOB can hold 4.2 GB, so you should be fine.
Real programmers don't comment their code. If it was hard to write, it should be hard to understand.