Netezza Performance Server extensions
To allow the usage of national character sets, Netezza Performance Server extends its character set support in
two ways. The features described for nchar are the same as those features for char.
- The char/varchar data type supports the ISO Latin-9 code set. Sort comparisons use the 8-bit ISO code point values 0-255 for string comparisons. Netezza Performance Server does not support other ISO/Latin code sets or language-specific collations.
- The ANSI SQL standard nchar/nvarchar (or national char) data type supports Unicode by using the UTF-8 encoding. Collation is in Unicode code point order.