List:General Discussion« Previous MessageNext Message »
From:Scott Hamm Date:August 10 2004 11:33am
Subject:RE: What would you store in a BLOB field?
View as plain text  
Are you saying that BLOB can store external files? I'm not sure if I
understood "storing any binary data" in a way you meant. I'm working on a
project where program dumps a file along with report that comes with it. I
was thinking maybe I could centerize multi programs' Data to Mysql...

I hope I'm wrong knowing what SQL is like...

-----Original Message-----
From: Egor Egorov [mailto:egor.egorov@stripped]
Sent: Tuesday, August 10, 2004 6:29 AM
To: mysql@stripped
Subject: Re: What would you store in a BLOB field?


"Levi Campbell" <levicc00123@stripped> wrote:

> I know the blob field is binary but what would you store there? and if =
> you could give me an example of real-life uses please.

You can store beer, juice or milk, but you need to escape the drink properly
to
get it back fresh and delicious.  ;) 

Speaking seriously, BLOB is capable of storing any binary data. There is a
long-lasting
religion war about whether it's good to store, say, images in BLOB or not. I
don't want
to dive in that flame, but I must admit that both ways (storing binary data
in BLOB or 
just a filename where the data is) has their pros and cons. 

Probably, the most popular real-life usage is storing generated website
images
(thumbnails) in BLOB fields. 






-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   Egor.Egorov@stripped
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
       <___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=1
Thread
What would you store in a BLOB field?Levi Campbell7 Aug
  • Re: What would you store in a BLOB field?Dan Nelson7 Aug
    • Re: What would you store in a BLOB field?Daniel Lahey7 Aug
  • Re: What would you store in a BLOB field?Rhino7 Aug
  • Re: What would you store in a BLOB field?Rhino7 Aug
  • Re: What would you store in a BLOB field?Egor Egorov10 Aug
RE: What would you store in a BLOB field?Scott Hamm10 Aug
  • RE: What would you store in a BLOB field?SGreen10 Aug
RE: What would you store in a BLOB field?Scott Hamm10 Aug