If a column c1 of type char(5) has a value “a” inserted into it, the following SQL statement will not return any rows if the table is on an Oracle database:
select...where c1 like "a"
Oracle does not make blank-padded comparison for arguments to like clauses. However, when executed against a table on ASE, the same SQL statement fetches the row.
Given the same setup, the following SQL statement returns the row when the table is on either ASE or Oracle:
select...where c1 = "a"
When c1 = “a” is used, Oracle performs blank-padded comparisons.