Blank spaces in Oracle

From: Carlserra <carlserra_at_hotmail.com>
Date: Mon, 29 Nov 1999 13:27:56 +0100
Message-ID: <81trj0$71d$1@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 Mon Nov 29 1999 - 06:27:56 CST