The SET SESSION COLLATION collation_name statement sets the default collation to be used when creating tables.

For more information, see the SQL Reference Guide.