Data Definition Language effects

Netezza Performance Server uses the default character and collation (SQL:1999) when you create databases.

CREATE DATABASE dbname WITH DEFAULT CHARACTER SET latin9 [ COLLATION binary ]

A binary collation means that the sort sequence is based on the numeric values of the characters that are defined by the character encoding scheme. Binary sorts are the fastest type of sort.