What about spaces in my data using a union in Oracle and MS Sqlserver

Situation

In datprof Integrate I have some Union queries where the data my or may not contain traling spaces.

I know that the Union statement removes duplicates from the result.

Given this base query:

Select 'A '
union
Select 'A'


Do Oracle and Microsoft treat this the  same?


Answer

No

Consider the code below.

Oracle query
select 'A '  from dual -- A with trailing space
union
select 'A'  from dual  -- A without trailing space

Result:
A 
A


MSS query
select 'A ' -- A with trailing space
union
select 'A'  -- A without trailing space

Result:
A 


As you can see Oracle treats  'A ' and 'A' as two distinctive values where MS Sql servers treats them as equal.

Quit a differnce.



integrate