Hai,
I am using longblob for my datatype. Maybe just forget about the big
file size. But how about the small file size? As the smallest file i can
save is 17KB. Through the MYSQL-front, i able to view my picture and confirm
that the picture already been save. Just yet don't know y even the small
file size also can't.
Thanks
----- Original Message -----
From: "Carsten Gehling" <[EMAIL PROTECTED]>
To: "Jenny" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, January 15, 2002 1:23 PM
Subject: Re: what is the limit for max_packet_size?
> ----- Original Message -----
> From: "Jenny" <[EMAIL PROTECTED]>
> Sent: Tuesday, January 15, 2002 5:14 AM
>
>
> > Finally i able to retrive image from MYSQL database via VB6.0.
> However, i can only retrieve image where the size is greate than 17kb and
> less then 32KB.
> >
> > I have try to increate my max_packet_size to 128KB, but i still
> retrive null value. Another thing i feel queries is, you the small file
size
> also can't??? Is somebody know face this problem b4?
>
> AFAIK there's no limit on MAX_PACKET_SIZE.
>
> What kind of field type do you use? The BLOB field can only contain 2^16 -
1
> bytes. Maybe you should use a LONGBLOB (2^32 - 1 bytes)
>
> - Carsten
>
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
