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
