*utf8_unicode_ci properly handles both French and German collation, so specific collation types for these languages are not necessary.

For more information, see the PostgreSQL 9.2 Documentation.

The SQL standard does not define a default collation. Therefore, many DBMS engines have different default collations and produce different results. As a result, there are several differences between Hyperstage and other DBMS engines.

• For Hyperstage, character data types are case-sensitive. For example, the condition 'toronto'='Toronto' is not true in Hyperstage. Similarly, the condition, LIKE 'Abc%' is not true for 'abcde'.
• The Hyperstage sorting order is A…Z a…z (for example 'Zeta' < 'alfa'), which is the same sorting order as used by Oracle. The Hyperstage sorting order is different than the default PostgreSQL sorting order, which mixes lowercase and uppercase. The SQL Server order, which is aAbB…zZ; and the DB2 order, which is AaBb…Zz.
• The Hyperstage sorting order affects ORDER BY results, GROUP BY results (which is the order of groups and their definitions (for example, 'aaa' and 'AAA' define different groups) and DISTINCT results. WHERE conditions may also be affected if you are expecting a different sorting order than the one used by Hyperstage.
• To simulate Hyperstage collation in the PostgreSQL engine, set latin1_bin collation while creating a table (for more information, see the PostgreSQL 9.2 Documentation). Enter the following command:

  psql> create table … collate ascii_bin;