On the other hand, what I think I may do is set up two VARCHAR2(4000)
fields -- one for content, and the other to act as an "overflow" field
-- then use PHP to count the number of chars going into the content
field. If it's more than 4000, PHP will split the data and insert the
"overflow" into the overflow field.
Damn Oracle and it's stupid limits! :-)
-B
--- Bob Sawyer <[EMAIL PROTECTED]> wrote:
> (I think the first time I tried this, I sent before I was done... if
> so, I apologize for the truncated post...)
>
> So, I'm not sure that I completely understand how a CLOB works in
> Oracle, although I believe it acts as a pointer to the actual data,
> which resides.... somewhere. I have the need to expand beyond the
> 4000-character limit in Oracle's VARCHAR2 field type, and believe
> CLOBs
> are the way to go. However, I'm not accessing Oracle via the standard
> PHP Oracle 8i calls or ADODB or PEAR or whatnot -- I'm using a DB
> abstraction script that takes pretty standard SQL and parses it for
> Oracle.*
>
> So my question is a two-parter:
>
> 1) Can someone adequately explain the oracle CLOB field type to me
> (Google was not my friend here), and
>
> 2) Assuming the SQL I'm using to access the data in the Oracle db
> looks
> like MySQL SQL*, how would I access the CLOB data?
>
> Thanks for the assist.
>
> -Bob
>
> * a typical Oracle query through the abstraction script looks like
> this:
> $foo = $db->get_row("select * from table_name where id = '$id'");
>
>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Community email addresses:
Post message: [email protected]
Subscribe: [EMAIL PROTECTED]
Unsubscribe: [EMAIL PROTECTED]
List owner: [EMAIL PROTECTED]
Shortcut URL to this page:
http://groups.yahoo.com/group/php-list
YAHOO! GROUPS LINKS
- Visit your group "php-list" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
