Re: [PHPLIB-DEV] cvs commit From: Kirill Maximov (kir <email protected>)
Date: 11/11/99

Massimiliano Masserelli wrote:
>
> On Thu, Nov 11, 1999 at 04:49:54PM +0300, Kirill Maximov wrote:
>
> KIR> BEGIN/END TRANSACTION is not supported by Oracle. In ct_split_sql I
> KIR> committed alternative for Oracle, so you can use it in BLOB class
> KIR> too.
>
> I'll do. Blob support is still VERY experimental. BTW, Oracle should also
> have a REAL blob support, isn't it? That's the point in the whole be_xxx
> classes.

  I tried to play with real Oracle BLOB support using Oracle7 API.
  And I failed to store value more then 2000 bytes to BLOB, though I
  used php Oracle API :(. It is not PHPLIB problem, but PHP. Or mine ;(

>
> KIR> What about ct_sql_blob class - sorry, i'm not sure that this class
> KIR> is really needed. I think that new kk's ct_split_sql class is
> KIR> sufficient for most purposes. And, probably, it should work faster -
> KIR> it uses less SQL calls because works with only one table.
>
> Yes, if you use ct_sql_blob with be_sql. Don't know if you use a proper
> be_xxx class with real blob support. Current implementation is intended
> to be a workable start in order to do some test, and maintain compatibility
> with those database engines which do not support blobs.

  May be you're right here. But I'm not sure that sessions data may
  require real BLOB (Binary and Large). Don't you want to store
  large images in session variables? Rather you'll store indices
  to database tables.

[skipped]

> KIR> And, IMHO, there is a sense to give an ability to give different
> KIR> encoding type support ala ct_split_sql offers.
>
> Yes, maybe you're right. I didn't bother implementing it because all be_xxx
> classes should be equivalent, and there's not much sense in specifying a
> particular encoding type when you deal with blob handling, which is
> intended to be BINARY.

   I had in mind possible search through BLOB data for the case
   when blob is text data. I even thought about some possible
   simple search function, which returns comma-separated
   id's of blobs found.

   With best regards,
   KIR 

-- 
-----  -----  -----  -----  -----  -----  -----  -----
Kirill Maximov                     maximov <email protected>  
Astrive, Inc.                   http://www.astrive.com
-
PHPLIB Developers Mailing List. Send messages to <phplib-dev <email protected>>.
To unsubscribe, send "unsubscribe" to <phplib-dev-request <email protected>> in
the body, not the subject, of your message.