I know, there is the database configuration parameter "Database collating sequence" for setting the collation in db2. But since this effects the whole database and can only be set when creating it, I'm looking for the possibility for setting this for a single table or column. Alternatively, setting the collation in the SQL statement, like you could do on Microsoft SQL Server:
SELECT * FROM table ORDER BY col1 COLLATE Latin1_General_CI_AS
Is this possible in DB2? How?
Secondly, how will changing the collation for either for the whole db, a table, or within a query effect the performance?