Soldato
I am trying to setup a Blob field in a mysql database and I am using phpMyAdmin to do so. The webserver/mysql database is running locally on my machine but for some reason when I try to add an image to the blob field from phpmyadmin, nothing is added and the field remains [BLOB - 0 B].
Now on my hosting internet server I can add an image the same way using phpmyadmin to a mysql database created on that server which then shows [BLOB - 33.8 KiB]
Is there something wrong with my, mysql installation or php installion on my machine that is preventing the uploading of BLOB content?
Cheers for any help.
EDIT:
Also if I try to add an image, I get this sql error #1364 - Field 'picture' doesn't have a default value
To get around this I have to set the field to NULL when creating it but I don't have to do this on my hosting server database. Could it be different versions of MySql server?
Hosting = 4.1.22-standard
Local machine wich I am having problems with = 5.0.45-community-nt
Now on my hosting internet server I can add an image the same way using phpmyadmin to a mysql database created on that server which then shows [BLOB - 33.8 KiB]
Is there something wrong with my, mysql installation or php installion on my machine that is preventing the uploading of BLOB content?
Cheers for any help.
EDIT:
Also if I try to add an image, I get this sql error #1364 - Field 'picture' doesn't have a default value
To get around this I have to set the field to NULL when creating it but I don't have to do this on my hosting server database. Could it be different versions of MySql server?
Hosting = 4.1.22-standard
Local machine wich I am having problems with = 5.0.45-community-nt
Last edited: