Re: Blank spaces in Oracle

From: Marc <E.Mail_at_address.com>
Date: Thu, 2 Dec 1999 07:47:41 +0100
Message-ID: <8254ne$efb$1@vkhdsu24.hda.hydro.com>

If you really want 'CARLOS ' to be equal to 'CARLOS, you should create your tables in Oracle with CHAR instead of VARCHAR2 (although I would normally not recommend to use the CHAR datatype).

create table marc (x char(10))
/

insert into marc values('CARLOS ')
/

select *
from marc
where x = 'CARLOS'

X

---

CARLOS Marc

Carlserra wrote in message <81trj0$71d$1_at_lola.ctv.es>...
>Hi:
>
>I have a problem.
>
>I exported a lot of data from SQL Server to Oracle. In SQL Server the
>expression 'CARLOS' is the same as 'CARLOS '. The second expression
>have 7 blank spaces but SQL Server thinks that the expressions are
>identical. But, In Oracle these expressions are different.
>
>What can i do with the great amount of data?. I have a lot of SQL
statements
>with select, insert... I don't want to modify then.
>Exists any configuration or flag to configure Oracle to work, in this case,
>like SQL Server?
>
>Thank you
>CARLSERRA.
>
>
Received on Thu Dec 02 1999 - 00:47:41 CST