Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: clob to varchar2 (+ I forgot to make some more contribution)
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