The COLLATION option defines the name for a collation sequence that determines the ordering of data characters during comparison operations and when sorting data in response to a SELECT query that includes an ORDER BY or WITH … BY clause.
You can override the COLLATION attribute during any session by running an appropriate SET SESSION COLLATION request (see SET SESSION COLLATION).