Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Trailing spaces trimmed by default?
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:18:30 CST