Re: inserting BLOB data

Here's a cool article:

http://www.james.rcpt.to/programs/mysql/blob/


--- Kenny Scott <[email protected]> wrote:

> Actually, there are more differences these days between blob and text
> columns.  But nothing major:
> 
> http://dev.mysql.com/doc/refman/5.0/en/blob.html
> 
> -- 
> Kenny
> 
> 
> On Dec 11, 2007 9:39 PM, Kenny Scott <[email protected]> wrote:
> > Hi,
> >
> > Well, the only difference between the text and blob column types,
> > afaik, is that a blob is a case sensitive text column.  Is the issue
> > that you have simply how to get the data in the table, rather than how
> > you would do it using Perl?  Or am I completely missing the point?
> >
> > --
> > Kenny
> >
> >
> >
> > On Dec 11, 2007 9:30 PM, Kiran Annaiah <[email protected]> wrote:
> > >
> > >
> > > No i havent yet tried using the perl script to insert the data. I was
> > > looking around and seems like it is done mostly using a script.
> > >
> > > No the file is not binary. It is just a one row of numbers(about half
> > > million columns)
> > > 0 12333 1 1 0 1 2 2 1 1 ....so on
> > >
> > > should i use a different data type instead of BLOB?
> > >
> > >
> > >
> > > ________________________________
> > > > Date: Tue, 11 Dec 2007 21:18:37 +0000
> > > > From: [email protected]
> > > > To: [email protected]
> > > > Subject: Re: inserting BLOB data
> > >
> > >
> > > >
> > > > Hi,
> > > >
> > > > What are the file contents? Is it binary data, which is why you're
> > > > wanting to use the BLOB column type?
> > > >
> > > > What have you tried so far, and has it not worked?
> > > >
> > > > I'm guessing that you've tried the following type of thing:
> > > >
> > > > my $dbh = DBI->connect( "dbi:mysql:test", "root" ) or die $DBI::errstr;
> > > > my $sth = $dbh->prepare( "INSERT INTO t SET file_name=?, file_size=?,
> > > file=?" );
> > > > $sth->execute( $file_name, $file_size, $file );
> > > > $sth->finish();
> > > >
> > > > Did you try that and it didn't work for some reason?
> > > >
> > > > --
> > > > Kenny
> > > >
> > > >
> > > > On Dec 11, 2007 8:44 PM, Kiran Annaiah <[email protected]> wrote:
> > > > > I am trying to store my file contents in a table. I have never worked
> > > with BLOB data types before.
> > > > > I realised that inserting the file contents into the BLOB column is not
> > > the same as inserting into a regular column.
> > > > >
> > > > > The file size is about 2.2M. I have set the system variable
> > > max_allowed_packet to 3M.
> > > > >
> > > > > Can anyone please give me some ideas about how the file contents can be
> > > inserted?
> > > > >
> > > > > Table structure is as follows.
> > > > >
> > > > >
> > > +-----------+-----------------------+------+-----+---------+----------------+
> > > > > | Field | Type | Null | Key | Default | Extra |
> > > > >
> > > +-----------+-----------------------+------+-----+---------+----------------+
> > > > > | file_id | smallint(5) unsigned | NO | PRI | NULL | auto_increment |
> > > > > | file_name | varchar(25) | NO | | | |
> > > > > | file_size | mediumint(8) unsigned | NO | | | |
> > > > > | file | mediumblob | NO | | | |
> > > > >
> > > +-----------+-----------------------+------+-----+---------+----------------+
> > > > >
> > > > >
> > > > > _________________________________________________________________
> > > > > i'm is proud to present Cause Effect, a series about real people making
> > > a difference.
> > > > > http://im.live.com/Messenger/IM/MTV/?source=text_Cause_Effect
> > >
> > > ________________________________
> > > i'm is proud to present Cause Effect, a series about real people making a
> > > difference. Learn more
> >
> 
> -- 
> MySQL Perl Mailing List
> For list archives: http://lists.mysql.com/perl
> To unsubscribe:    http://lists.mysql.com/[email protected]
> 
> 


-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/[email protected]