Re: Why are data types size limited?

"Joe \"Nuke Me Xemu\" Foster" <joe_at_bftsi0.UUCP> wrote:

>I can imagine a scheme which allows memos to be indexed. Only a

sure, but when does it really make sense to index a blob? ...ordering blobs because of differences in the 123456th char?

>"reasonable" number of bytes are actually indexed, and another

that's what sqlaw does, for example

>"reasonable" number of bytes are actually stored in the record,
>with the rest stored wherever BLOB data is stored currently. If

sounds like paradox's memo-implementation, doesn't it?

>the text data is kept within "reasonable" bounds, performance
>is near what is currently acceptable for varchar data. However,
>if someone actually has an email address longer than 255 or so
>characters, it won't cause havoc in an app.

agreed, to be honest i don't understand why oracle for example makes an explicit difference between c(-haracter-)lobs and varchar2. probably historical reasons

ciao, jan

http://www.rsp.de/

rs&p-Dossier: Software zur Erstellung technischer Dokumentationen

              und Schriftgutes in Verwaltung und Industrie. Received on Fri Mar 24 2000 - 00:00:00 CET