----- 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