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
On Fri, Jan 10, 2003 at 04:36:07PM -0600, Terry & Cheryl Haimann wrote:
> Is there an easy way to see If and how much data I have written into a blob?
You can find the length of a blob in bytes using the LENGTH function:
SELECT LENGTH(column) FROM table;
You can also use BIT_LENGTH to fi
At 16:36 -0600 1/10/03, Terry & Cheryl Haimann wrote:
Is there an easy way to see If and how much data I have written into a blob?
LENGTH(blob_col_name) might be what you want.
sql...tomakefilterhappy
-
Before pos
On Tue, 13 Aug 2002, Mauricio Sthandier R. wrote:
> I'm working with BLOBs in mySQL and Visual Basic... i read that
> storing images in the database has worst performance than the
> filesystem, but anyway I'm planning to store them in MediumBlobs. My
> specific problem is that I don't know if I'm
I store images in the database for a few reasons. I do make sure they are
in their own table though and link to another table via a key so I would
have tbllisting with all the textual data information on a listing and then
tbllisting_image which is just the primary key linking to tbllisting and a
Why store the pic in the DB?
I know there is an ASP upload utility avaliable.
Try www.asp101.com or www.hotscripts.com
HTH
Mark
-Original Message-
From: Zill-e-Hassan <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Thursday, April 25, 2002 1:48 PM
Subject: Blobs+ASP+
This is quite easy. SciBit developed an ASP COM Object called MySQLX
(http://www.scibit.com/MySQLX) which does exactly what you want, this component is
almost two years old now and is very stable and used world-wide in many
applications/webs including real-time apps.
The help is a bit sparse
I would be interested in this too. With a corollary: does anyone know of
a small script other than java applets that would effectively place a
freehand drawtool on the webpage, and capture the resulting image for
insertion as a db blob?
Andrew Hazen
-Original Message-
From: Zill-e-Hassa
On Thu, Aug 23, 2001 at 05:07:35PM -0500, Gary Jollymore wrote:
>
> how would i get a file such as /files/photo.jpg into a mysql table
> such as
>
> create table photo ( code decimal(6,0), photo blob);
>
> i tried insert into photo values('4142','/files/photo.jpg'); which
> of course just put th
