Re: Question about BLOB

2005-08-03 Thread Philippe Poelvoorde
Gelu Gogancea wrote: I use mysql C API and for *escaping* the data i use the mysql_real_escape_string()the mysql native function. Thanks, Make sure to use mysql_real_query with the right length. because mysql_query is a macro for mysql_real_query with an additionnal parameters given by st

RE: Question about BLOB

2005-08-03 Thread Gelu Gogancea
mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] -Original Message- From: Philippe Poelvoorde [mailto:[EMAIL PROTECTED] Sent: Wednesday, 03 August, 2005 9:58 AM To: 'mysql@lists.mysql.com ' Subject: Re: Question about BLOB Gelu Gogancea wrote: > Hi, > Is not the first t

Re: Question about BLOB

2005-08-02 Thread Philippe Poelvoorde
Gelu Gogancea wrote: Hi, Is not the first time when i read this this page. So, the conclusion is that until MySQL version 5.0.3 the empty spaces are remove if i wish to store the binary data in a table. Is not any other solutions?Because for the moment i convert the binary data into ASCII(print

Re: Question about BLOB

2005-08-02 Thread Jason Pyeron
. Teddy - Original Message - From: "Gelu Gogancea" <[EMAIL PROTECTED]> To: "Jay Blanchard" <[EMAIL PROTECTED]>; "MySQL mailing list" Sent: Tuesday, August 02, 2005 13:50 PM Subject: RE: Question about BLOB Hi, Is not the first time when i read

Re: Question about BLOB

2005-08-02 Thread Jason Pyeron
I have never had a problem storing BLOBs in MySQL or any other DB for that fact. I have on many occasions forgot to use the proper methods for send a BLOB to the db. That means proper escaping, etc. On Tue, 2 Aug 2005, Andy Hilton wrote: In my data structure I have many BLOBs which are no

Re: Question about BLOB

2005-08-02 Thread Andy Hilton
;Jay Blanchard" <[EMAIL PROTECTED]>; "MySQL mailing > list" > Sent: Tuesday, August 02, 2005 13:50 PM > Subject: RE: Question about BLOB > > > Hi, > Is not the first time when i read this this page. > So, the conclusion is that until MySQL version 5.0.3

Re: Question about BLOB

2005-08-02 Thread Octavian Rasnita
ROTECTED]> To: "Jay Blanchard" <[EMAIL PROTECTED]>; "MySQL mailing list" Sent: Tuesday, August 02, 2005 13:50 PM Subject: RE: Question about BLOB Hi, Is not the first time when i read this this page. So, the conclusion is that until MySQL version 5.0.3 the empty space

RE: Question about BLOB

2005-08-02 Thread Gelu Gogancea
OPER http://www.gonetsoftware.com Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] -Original Message- From: Jay Blanchard [mailto:[EMAIL PROTECTED] Sent: Monday, 01 August, 2005 8:41 PM To: Gelu Gogancea; MySQL mailing list Subject: RE: Question about BLOB [snip] I have a t

RE: Question about BLOB

2005-08-01 Thread Jay Blanchard
[snip] I have a table with a MEDIUMBLOB field and i wish to store a picture(.BMP) which the size is 10622 bytes.But when i look into the table i see only 9582 bytes. Please, i wish to know for what reason on the table are few bytes than original. I use MySQL 5.0 - Fedora Core 3 [/snip] Have a loo

Question about BLOB

2005-08-01 Thread Gelu Gogancea
Hi, I have a table with a MEDIUMBLOB field and i wish to store a picture(.BMP) which the size is 10622 bytes.But when i look into the table i see only 9582 bytes. Please, i wish to know for what reason on the table are few bytes than original. I use MySQL 5.0 - Fedora Core 3 Thanks, ___

Re: Newbie question about blob data types ie. Storing .xls in blob

2004-09-27 Thread DreamWerx
Good binary storage article w/ sample code: http://php.dreamwerx.net/forums/viewtopic.php?t=6 On Mon, 27 Sep 2004 16:47:37 -0500, Jack Taffar <[EMAIL PROTECTED]> wrote: > > Is it possible to store an excel file into a blob field in mysql? If so how > do I go about importing the file into the b

Newbie question about blob data types ie. Storing .xls in blob

2004-09-27 Thread Jack Taffar
Is it possible to store an excel file into a blob field in mysql? If so how do I go about importing the file into the blob field, and get it back out into an .xls file? Thanks in advnace Jack Taffar AOG -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsu