We are using a tool called Cosmos to transfer data from Sybase to Oracle. It seems that in some cases it is transferring character data into varchar2 fields with trailing spaces. I thought that varchar2 fields were used specifically to omit trailing spaces when data is saved.
so a code '03' is actually saved as '03 ' (apostrophes omitted in data)
Could someone explain to me the behavior I should expect out of a varchar2 when leading spaces are possible?