Re: Max Size of Datatype

On Sep 20, 3:14 am, Robert Klemme <shortcut..._at_googlemail.com> wrote:
> On 19.09.2007 23:47, Terry Dykstra wrote:
>
>
>
>
>
> > <ame..._at_iwc.net> wrote in message
> >news:1190237744.501586.138180_at_y42g2000hsy.googlegroups.com...
> >> Hi All,
>
> >> We are currently on Oracle 8i, but in about 2 months we are moving to
> >> 10g.
>
> >> Anyhow, we need to store more than 4000 bytes in a certain column.
> >> How can I do that in 8i, such that it will not create a problem when
> >> moving it to 10g? Additionally, I do not want to break anything that
> >> currently uses the column I need to alter.....
>
> >> Thanks in advance.
>
> > The only way is to start using a BLOB. And that will break your
> > applications.
>
> In case the OP needs to store character data I'd use CLOB or NCLOB
> instead of BLOB.
>
> http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a853...
>
> Kind regards
>
> robert- Hide quoted text -
>
> - Show quoted text -

Definitely use a LOB datatype usually BLOB or CLOB as Terry suggested. See the supplied package dbms_lob as well as the Application Developers Guide - Large Objects for details on usage.

HTH -- Mark D Powell -- Received on Fri Sep 21 2007 - 08:54:05 CDT