Compatibility Issues

In versions earlier than 12.0, Sybase IQ always used the ASCII sort order, which sorts uppercase characters before lowercase.

In 12.4.2 and later versions, by default IQ databases sort data in the same way as pre-version 12 Sybase IQ. The default applies these CREATE DATABASE options:

CREATE DATABASE dbname
COLLATION 'ISO_BINENG' 
BLANK PADDING ON 
CASE RESPECT

With these options, uppercase characters precede all lowercase characters in the collation sequence. For example, 'XYZ' sorts before 'abc' with these options, just as it did in older versions of Sybase IQ.