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:[EMAIL PROTECTED] Sent: Tuesday, August 10, 2004 6:29 AM To: [EMAIL PROTECTED] Subject: Re: What would you store in a BLOB field? "Levi Campbell" <[EMAIL PROTECTED]> 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 / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ 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/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
