blobs in mysql

2003-10-22 Thread Scott Purcell
Hello, I have opted to insert some small jpg files into the mysql database using java. Code below. When I do a select from the table using the mysql command line, it generates pages of ---

Re: blobs in mysql

2003-10-22 Thread colbey
I usually use ps.setBytes() and pass it a byte[] array .. On Wed, 22 Oct 2003, Scott Purcell wrote: Hello, I have opted to insert some small jpg files into the mysql database using java. Code below. When I do a select from the table using the mysql command line, it generates pages of

Re: Blobs+ASP+MySQL

2002-04-27 Thread Mark Stringham
+MySQL Dear All I have been trying to find out if there is a way of actually storing pictures as Blobs in MySql . Eventually i want to upload and download pictures to/from the database through the use of ASP. I would also welcome any suggestions that you guys may have regarding how to upload

Blobs+ASP+MySQL

2002-04-25 Thread Zill-e-Hassan
Dear All I have been trying to find out if there is a way of actually storing pictures as Blobs in MySql . Eventually i want to upload and download pictures to/from the database through the use of ASP. I would also welcome any suggestions that you guys may have regarding how to upload the image

RE: Blobs+ASP+MySQL

2002-04-25 Thread Andrew Hazen
-Hassan [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 25, 2002 4:02 PM To: [EMAIL PROTECTED] Subject: Blobs+ASP+MySQL Dear All I have been trying to find out if there is a way of actually storing pictures as Blobs in MySql . Eventually i want to upload and download pictures to/from the database

RE: Blobs+ASP+MySQL

2002-04-25 Thread [EMAIL PROTECTED]
in Delphi/Kylix using our components (http://www.scibit.com/MySQLComponents). Kind Regards SciBit MySQL Team -Original Message- From: Zill-e-Hassan [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] CC: Subject: Blobs+ASP+MySQL Sent: Thu, 25 Apr 2002 20:02:19 GMT Received: Thu

Re: Very large BLOBS in MySQL 4.0.1

2002-04-05 Thread Martin Mokrejs
Adriano Manocchia wrote: Well, first off, I can't seem to get max_allowed_packet higher than 64 MB on the server using 3.23.x or 4.0.1. Changes made to /etc/my.cnf are reflected in the system settings, but only up to 64 MB, then regardless of what I put in there, it stays at 64 MB. But

Re: Very large BLOBS in MySQL 4.0.1

2002-04-01 Thread Adriano Manocchia
Well, first off, I can't seem to get max_allowed_packet higher than 64 MB on the server using 3.23.x or 4.0.1. Changes made to /etc/my.cnf are reflected in the system settings, but only up to 64 MB, then regardless of what I put in there, it stays at 64 MB. But like I said, the file is only

Re: Very large BLOBS in MySQL 4.0.1

2002-03-30 Thread Peter Zaitsev
Hello Adriano, Friday, March 29, 2002, 11:38:32 PM, you wrote: As I remember there are max_allowed_packet options exists both for client and server. You may wish to try to raise both of them. AM I've been using a perl script to insert a very large blob (up to about 8 AM MB) into a DB

Very large BLOBS in MySQL 4.0.1

2002-03-29 Thread Adriano Manocchia
I've been using a perl script to insert a very large blob (up to about 8 MB) into a DB successfully, but now I need to do it with a 34 MB BLOB, so I upgraded to MySQL 4.0.1. First off, I can't get max_allowable_packet to go higher than 64M, regardless of what I set it to, but that shouldn't

Re: Very large BLOBS in MySQL 4.0.1

2002-03-29 Thread Colin Faber
It sounds to me that you're exceeding the maximum packet size mysql can handle. Adriano Manocchia wrote: I've been using a perl script to insert a very large blob (up to about 8 MB) into a DB successfully, but now I need to do it with a 34 MB BLOB, so I upgraded to MySQL 4.0.1. First off,