forums › forums › SQLyog › Using SQLyog › Size Limits On Uploaded Photos
- This topic is empty.
-
AuthorPosts
-
-
October 2, 2006 at 5:54 pm #22655
peterlaursen
ParticipantThere is no such (known) issue with SQLyog. Attached a BLOB of almost 3 MB (SQLyog 5.2 beta5)
But please upgrade SQLyog and try again – though I am 99% sure that there was no such issue with 5.16 either.
Are you connecting with HTTP-tunneling? There could be some buffer or time-out issue on the network.
PHP/webserver(Apache)/releay server settings are my best guess. Neither SQLyog nor MySQL, I think.
SQLyog sends the data, it is all delivered to the remote network, but inside that netwok some of it gets lost.
If you create a ticket I can arrange access to a database on another server (tomorrow!).
Upgrades: http://www.webyog.com/en/download_latest_sqlyog.php
-
October 2, 2006 at 6:43 pm #22656
Tarheel
MemberI upgraded to the 5.2 beta5 and as you predicted, it did not solve the problem.
I then changed the field from BLOB to LONGBLOB and that solved it. I just uploaded a ~600KB image file successfully. Thanks for your prompt response. I am very pleased the SQLyog program.
peterlaursen wrote on Oct 2 2006, 01:54 PM:There is no such (known) issue with SQLyog. Attached a BLOB of almost 3 MB (SQLyog 5.2 beta5)But please upgrade SQLyog and try again – though I am 99% sure that there was no such issue with 5.16 either.
Are you connecting with HTTP-tunneling? There could be some buffer or time-out issue on the network.
PHP/webserver(Apache)/releay server settings are my best guess. Neither SQLyog nor MySQL, I think.
SQLyog sends the data, it is all delivered to the remote network, but inside that netwok some of it gets lost.
If you create a ticket I can arrange access to a database on another server (tomorrow!).
Upgrades: http://www.webyog.com/en/download_latest_sqlyog.php
-
October 2, 2006 at 7:03 pm #22657
peterlaursen
ParticipantOK …
you can read about the max. storage size of different variable types here:
http://dev.mysql.com/doc/refman/5.0/en/sto…quirements.html
BLOB: 2^16 byte ~64 KB
MEDIUBLOB: 2^24 byte ~ 1.6 MB
LONGBLOB: 2^32 byte ~ 4 GB
Data are truncated if they are too big. However I did not notice because my image was a Interlaced TIFF image and with that resolution it displayed OK actually (there were lots of 'holes' in it but they were not visible). A .JPG on the opposite will simply be cut off!
-
-
AuthorPosts
- You must be logged in to reply to this topic.