Re: LONG VARCHAR

From: Howard J. Rogers <howardjr_at_www.com>
Date: 2000/07/15
Message-ID: <397080a6$1@news.iprimus.com.au>#1/1

"Julien Godfroid" <j.gofdfroid_at_co-link.be> wrote in message news:396C8FF1.73EBC450_at_co-link.be...
> Hi
>
> I'm exporting a database from Sybase to Oracle8 and I've got a problem
> with LONG VARCHAR fields. They're not limited in number(in a same table)
> in sybase but seems to be in Oracle. Am I Right ? Is there a magic
> solution ?
>

No such thing as a long varchar, but if you are talking about LONGs and LONG RAWs then, yes, there's a limit of one such field per table.

If you have the chance to work with Oracle 8 and above, then you can use CLOBS and BLOBS which are (respectively) the replacements for LONGs and LONG RAWs -and you can have any number of those in an Oracle 8 table.

Not magic, but I hope it'll do,

Regards
HJR
> Thanks
>
> Ju
>
Received on Sat Jul 15 2000 - 00:00:00 CDT