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

Home -> Community -> Usenet -> c.d.o.server -> Re: clob to varchar2 (+ I forgot to make some more contribution)

Re: clob to varchar2 (+ I forgot to make some more contribution)

From: Galen Boyer <galenboyer_at_yahoo.com>
Date: 14 May 2001 21:16:06 -0500
Message-ID: <uu22n4aw5.fsf@primix.com>

On Mon, 14 May 2001, gunfus_at_yahoo.com wrote:

> 2) A varchar2(3000) will always be a 3000 character cloumn,
> which indeed it cam bring you a whole bunge of problems. This
> happends because Oracle will pad the empty space of the field
> with "_" characters or " " (can't remenber which one" and it

Huh? I do believe you mean char(x) column even though your 3000 number is off as well. varchar2() is just what you would think it is, variable size, based on the data.

> makes the column not very reliable

Makes the poster not very reliable.

-- 
Galen
I don't want to be the rock.  Yeah, okay, what do you want to be?
I want to be the piece of glass.
Received on Mon May 14 2001 - 21:16:06 CDT

Original text of this message

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