Re: OCINewDescriptor & long fields
| From: | thies at digicol dot de | Date: | Fri, 25 Aug 2000 10:24:43 +0000 |
| Subject: | Re: OCINewDescriptor & long fields | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-2369@lists.php.net to get a copy of this message | ||
On Thu, Aug 24, 2000 at 09:07:25AM -0700, Vince LaMonica wrote:
> On 2000-08-24, Arjan Haverkamp stated:
>
> } I installed PHP4.0.1pl2 and Oracle8i, it all works beautifully together.
>
> Those are dangerous words here - a lot of folks will be e.mailing you, I'm
> sure. :-)
>
> } Does anybody now how to get more than 4000 characters into an Oracle
> } long column???
>
> It isn't possible. 4000 char is the limit in 8.1.6. Maybe in 8.2 [they
> already moved from a 2000 char limit to 4000 in 8.1.6, so i'm not sure if
> there is much demand for this]. But according to several Oracle dbas here,
> going past the 4000 char limit in a long isn't possible; no
> workarounds. :(
you are wrong: the limit for LONG is 2GB in 7.x, 8.0.x and
8.1.x
oracle recoments _not_ to use longs (but clobs instead) and
long-support will dissapear in some future oracle release
(v25?;-)
tc
>
> /vjl/
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
> For additional commands, e-mail: php-db-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
--
Thies C. Arntzen "One Big-Mac, Small Fries and a Coke!"
Digital Collections Phone +49 40 235350 Fax +49 40 23535180
Hammerbrookstr. 93 20097 Hamburg / Germany