CREATE DATABASE no longer supports BLANK PADDING OFF for new databases. This change has no effect on existing databases.
Sybase recommends that you change any existing columns affected by BLANK PADDING OFF, to ensure correct join results. Recreate join columns as CHAR data type, rather than VARCHAR. CHAR columns are always blank padded. You can test the state of existing databases using the BlankPadding database property:
select db_property ( ‘BlankPadding’ )
