Re: Max Size of Datatype

From: Robert Klemme <shortcutter_at_googlemail.com>
Date: Thu, 20 Sep 2007 09:14:13 +0200
Message-ID: <5lekubF7r5j8U1@mid.individual.net>

On 19.09.2007 23:47, Terry Dykstra wrote:

> <amerar_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/a85397/sql_elem.htm#45443

Kind regards

        robert Received on Thu Sep 20 2007 - 02:14:13 CDT