Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Trailing spaces trimmed by default?
On Nov 6, 10:13 am, "Tarby777" <nick_william..._at_mentorg.com> wrote:
> Hi all,
>
> When doing either of these operations in 9i:
>
> create table x as (select * from y);
>
> insert into x(a,b,c) (select a,b,c from y);
>
> ...does Oracle trim trailing spaces from varchar2 columns by default
> and if so, can it be over-ridden? I'm losing some trailing spaces from
> my data during an upgrade and I suspect that one of these operations is
> causing it but I've not been able to reproduce the problem in tests...
>
> TIA
> Tarby
Received on Mon Nov 06 2006 - 03:50:29 CST