Collation can be set or changed several different ways:
- At the user-definition level with the CREATE USER or MODIFY USER statements.
- At the session level with the SQL SET SESSION COLLATION statement.
You can use predefined macros to change the collation default to Swedish, Norwegian, or the appropriate Japanese standard collation.
You can also define and install your own collation sequences, as explained in Defining Your Own Collation Sequence.