Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: large multi-byte char column strategies

Re: large multi-byte char column strategies

From: Todd <gdulli_at_zdnetmail.edu>
Date: 31 May 2001 01:18:10 GMT
Message-ID: <3b159bd2$0$17897@news.denver1.Level3.net>

In article <3B148B60.4ACB57A2_at_exesolutions.com>, dmorgan_at_exesolutions.com says...
>
>Todd wrote:
>
>>
>> Generally, I'm looking for the best strategy for supporting a >4000
>> multi-byte char column while optimizing for the majority of values being
>> smaller. Advice or pointers to literature would be appreciated.
>>
>> Thanks! - Todd (gdulli_at_zdnetmail.edu - change edu to com)
>
>Forget LONGs. They are going away in the next version of Oracle. Use a CLOB
>and search with InterMedia.
>
>Daniel A. Morgan

   Good to know, since we'll be on 9i relatively early. I didn't think to check if InterMedia supported NCLOBs, I'll look into it. Thanks.

   Todd Received on Wed May 30 2001 - 20:18:10 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US