This topic is locked

DB-Image size

1/9/2005 12:36:05 PM
ASPRunnerPro General questions
M
Matth author

Hi
I am trying to upload images to a database. This works like it should, but whenever I upload an image that is bigger than 64KB it only stores the first 64KB and the rest is ommitted.
If I save the file manually in the database it works with no problem.
How can I upload bigger images?
Thanks

Matthias

Sergey Kornilov admin 1/14/2005

Matthias,
I can upload images several megs in size - seems to be working just fine.
What database do you use and what is the field type?

M
Matth author 1/30/2005

Hi
I have a mySQL-Database and the field type is "blob".
When I upload the file using a database-client I can upload the whole picture.
And on the list-page it also only displays the first 64KB, although the whole file (.jpg) is in the database.
Matthias

Sergey Kornilov admin 1/30/2005

Matthias,
Please zip and send to support@xlinesoft.com the whole content of ASPRunner output folder ( ASP files, include files, MySQL database, project file and sample JPEG picture. I'll find what's wrong running it on my test box.

M
Matth author 1/30/2005

Oops, sorry. I found the error. Normal blob-fields only hold 64KB...
Changed that to long-blobs and now it works.
Matthias