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
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
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
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]
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]
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:
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
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
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
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]
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
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.
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
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
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,
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
16 matches
Mail list logo