Command SET COLLATION Foundation
Selects a collation table for characters.
SET COLLATION TO [ ASCII | DIN | SYSTEM | ; AMERICAN | ; BRITISH | ; DANISH | ; DUTCH | ; FINNISH | ; FRENCH | ; GERMAN | ; GREEK437 | ; GREEK851 | ; ICELANDIC850 | ; ICELANDIC861 | ; ITALIAN | ; NORWEGIAN | ; PORTUGUESE | ; SPANISH | ; SWEDISH ]
The command SET COLLATION selects the collation table that defines the sorting sequence of characters. Depending on the collation table, a single character can have different weighing factors for lexical string comparisons. This is important for index creation when characters are to be sorted according to their lexical meaning instead of their ASCII value. Language-specific special characters can be sorted correctly in this way.
If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.