How to fill an Blob with binary data

2003-05-27 Thread Thomas Hoelsken
Hi, I would like to fill an Blob with binary data thru SQL-statements or any other MySQL tools and don't know how!? Are there suggestions? Thanks, Thomas Hoelsken -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: How to fill an Blob with binary data

2003-05-27 Thread colbey
Search the mailing list archives for this... There is a link to this article: http://www.php4.com/forums/viewtopic.php?t=6 I wonder if the mailinglist search was powered by google more people would use it? On Tue, 27 May 2003, Thomas Hoelsken wrote: Hi, I would like to fill an Blob with

RE: How to fill an Blob with binary data

2003-05-27 Thread Mike Hillyer
I know MySQL CC can place a text or image blob into the database, might be worth a look. Mike Hillyer www.vbmysql.com -Original Message- From: Thomas Hoelsken [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 10:54 AM To: [EMAIL PROTECTED] Subject: How to fill an Blob with binary

RE: How to fill an Blob with binary data

2003-05-27 Thread Thomas Hoelsken
Hi, isn't there any other solution instead of using PHP just for filling an Blob!? I don't need php and would prefer any other way! Thanks, Thomas -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 6:56 PM To: [EMAIL PROTECTED]

RE: How to fill an Blob with binary data

2003-05-27 Thread colbey
Mascon can do it .. it's a win32 app.. On Tue, 27 May 2003, Thomas Hoelsken wrote: Hi, isn't there any other solution instead of using PHP just for filling an Blob!? I don't need php and would prefer any other way! Thanks, Thomas -Original Message- From: [EMAIL PROTECTED]

RE: How to fill an Blob with binary data

2003-05-27 Thread Adam Clauss
I am in need of help with the same question (sent late last night, but apparently got passed over). Adam Clauss [EMAIL PROTECTED] -Original Message- From: Thomas Hoelsken [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 12:11 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject:

RE: How to fill an Blob with binary data

2003-05-27 Thread Mike Hillyer
Like I said, for Image and text blobs, use MyCC and it should work. Mike Hillyer www.vbmysql.com -Original Message- From: Adam Clauss [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 11:18 AM To: [EMAIL PROTECTED] Subject: RE: How to fill an Blob with binary data I am in need of

RE: How to fill an Blob with binary data

2003-05-27 Thread Keith C. Ivey
On 27 May 2003 at 19:10, Thomas Hoelsken wrote: isn't there any other solution instead of using PHP just for filling an Blob!? Of course there is, but if you need more specifics you need to give us more details. How are you executing your SQL statements? It's just a matter of getting your

RE: How to fill an Blob with binary data

2003-05-27 Thread Thomas Hoelsken
Thanks, FreeMascon is able to do it und it works fine. If anyone knows another solution, I'm interested in! Thomas --- _ / __// __// ___/Thomas Hoelsken [EMAIL PROTECTED] / /_ / __// /_ / IT-Coordinator /___//_/ // Operations Control FRA HE/I

RE: How to fill an Blob with binary data

2003-05-27 Thread Adam Clauss
In my case, its neither. Some random binary data. Could be ANY kind of file... (I'm doing mine programmatically). Adam Clauss [EMAIL PROTECTED] -Original Message- From: Mike Hillyer [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 12:23 PM To: Adam Clauss; [EMAIL PROTECTED]

RE: How to fill an Blob with binary data

2003-05-27 Thread Christensen, Dave
What is the source of the binary data you want to use to fill the blob? -Original Message- From: Mike Hillyer [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 12:23 PM To: Adam Clauss; [EMAIL PROTECTED] Subject: RE: How to fill an Blob with binary data Like I said, for Image and

RE: How to fill an Blob with binary data

2003-05-27 Thread Mike Hillyer
In what language? Mike Hillyer www.vbmysql.com -Original Message- From: Adam Clauss [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 11:30 AM To: Mike Hillyer; [EMAIL PROTECTED] Subject: RE: How to fill an Blob with binary data In my case, its neither. Some random binary data.

RE: How to fill an Blob with binary data

2003-05-27 Thread Adam Clauss
Copied from my original message: I am writing a database that will contain a blob field for some binary data. My question is, what is the most efficient way to load this binary data in? I could turn it into a string and pass it into an INSERT/UPDATE statement, but I am afraid that problems will

RE: How to fill an Blob with binary data

2003-05-27 Thread colbey
Depending on size of data there are a few different methods... Just like what most people do.. use plain insert statements with the data properly escaped and shouldn't have any problem going in. Pulling data out is pretty quick .. I can stream binary data out of my mysql storage servers via our

RE: How to fill an Blob with binary data

2003-05-27 Thread Karam Chand
Hello I prefer SQLyog at http://www.webyog.com/sqlyog Its FREE, extremely fast and very easy to use. Runs only on Windows though. Should give a try!!! Karam --- Thomas Hoelsken [EMAIL PROTECTED] wrote: Thanks, FreeMascon is able to do it und it works fine. If anyone knows another solution,

RE: How to fill an Blob with binary data

2003-05-27 Thread Adam Clauss
OK question then - when I use LOAD_FILE, does it automatically put escape characters in front of anything that needs it? I am in development on an SMTP server with an SQL backend rather than simply a filesystem. My concern is regarding file attachments which could be pretty much anything