Joins between char columns and varchar columns may not return any rows. In addition, a query returns no rows when run directly against Oracle. However, when you run the query against ASE with the same data, it returns rows. The difference occurs because Sybase and Oracle have different comparison rules when the columns are not all fixed length. The workaround is to alter the table definitions so the column definitions match.
