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.
