About BLOBS

2002-04-11 Thread Hisseine Dj.

Hello,

Does MySqL database supports BLOBs operation? (Insert, delete etc ...)
If yes which API can use to do these operations? (MySqL++)?


Thanks for help





-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: About BLOBS

2002-04-11 Thread Paul DuBois

Hello,

Does MySqL database supports BLOBs operation? (Insert, delete etc ...)

Yes.

If yes which API can use to do these operations? (MySqL++)?

Any.  BLOB columns are just character columns.  They need not be
accessed in separate hunks like in some other databases.


Thanks for help


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: About BLOBS

2002-04-11 Thread Hisseine Dj.

Thanks Paul,

Hisseine

- Original Message - 
From: Paul DuBois [EMAIL PROTECTED]
To: Hisseine Dj. [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, April 11, 2002 10:40 AM
Subject: Re: About BLOBS


 Hello,
 
 Does MySqL database supports BLOBs operation? (Insert, delete etc ...)
 
 Yes.
 
 If yes which API can use to do these operations? (MySqL++)?
 
 Any.  BLOB columns are just character columns.  They need not be
 accessed in separate hunks like in some other databases.
 
 
 Thanks for help
 
 



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: About BLOBS

2002-04-11 Thread Victoria Reznichenko

Hisseine,
Thursday, April 11, 2002, 5:21:09 PM, you wrote:

HD Does MySqL database supports BLOBs operation? (Insert, delete etc ...)
HD If yes which API can use to do these operations? (MySqL++)?

BLOB are just the same thing as other field types. You can use
INSERT, UPDATE, DELETE statements to work with tables that has 
BLOB fields. You can read about BLOB types at:
 http://www.mysql.com/doc/B/L/BLOB.html
 
To add file to the BLOB column you can use LOAD_FILE() function, look
at:
 http://www.mysql.com/doc/S/t/String_functions.html

If you don't use LOAD_FILE don't forget to escape special chars in
your query. See http://www.mysql.com/doc/S/t/String_syntax.html for
more info about strings and blobs.

In the MySQL++ documentation you can find example how to load binary
file to a BLOB column, look at:
 
http://www.mysql.com/documentation/mysql++/4_Tutorial.html#SECTION03161000

HD Thanks for help




-- 
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   www.mysql.com




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php