Re: VARCHAR2 greater than 4K?

From: Mikito Harakiri <mikharakiri_at_ywho.com>
Date: Tue, 5 Aug 2003 16:03:31 -0700
Message-ID: <SQWXa.16$6O5.112@news.oracle.com>

"Anurag Varma" <avdbi_at_hotmail.com> wrote in message news:LKVXa.27506$r61.9329_at_news02.roc.ny...
> Max length for a varchar2 column is 4000 bytes.

OK. They can motivate that by storage design.

> Max length for pl/sql varchar2 datatype is 65535 bytes.

But I wonder how do they motivate this limitation, given that any decent language have a type String of unrestricted length (no string attached;-) Are they still living in 16 bit world?

> Define column as CLOB if you need a bigger column size.

Three datatypes for a character string? That's a little bit too much.

Here is small example demonstrating how ridiculous LOB implementation is:

SQL> select substr('hello world', 1, 4) from dual;

SUBS

---

hell

SQL> select dbms_lob.substr('hello world', 1, 4) from dual;

DBMS_LOB.SUBSTR('HELLOWORLD',1,4)

---

l Received on Tue Aug 05 2003 - 18:03:31 CDT