This content has been marked as final. Show 3 replies
The right character type for character data larger than 4000 bytes is CLOB.
LONG data type has a lot of restrictions which CLOB data type does not have: what are CLOB restrictions you are facing ?
the CLOB restrictions that i am facing are:
1. cannot specify a LOB as a primary key column.
2. cannot specify LOB columns in the ORDER BY clause of a query, or in the GROUP BY clause of a query or in an aggregate function.
3. cannot specify a LOB column in a SELECT... DISTINCT or SELECT... UNIQUE statement or in a join.
I am trying to create fields that can contain both short names and long text.
Edited by: 921776 on Mar 20, 2012 9:23 AM
But do you really need to have a primary key column longer than 4000 bytes or to sort by column longer than 4000 bytes ?