3 Replies Latest reply: Mar 20, 2012 12:45 PM by P.Forstmann RSS

    long char data type

    924779
      Is there a data type in Oracle that is longer then 4000 bytes and does not have the restrictions of LOB or LONG data types?
        • 1. Re: long char data type
          P.Forstmann
          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 ?
          • 2. Re: long char data type
            924779
            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
            • 3. Re: long char data type
              P.Forstmann
              But do you really need to have a primary key column longer than 4000 bytes or to sort by column longer than 4000 bytes ?