MySql character-set for sorting data

[Taki]

Someone could guide me if it is possible to use a specific charset for data sorting in mysql on a per user/database basis.
I know that it can be done by default when starting mysqld by using the option:
--default-character-set=[charset]
but I am not sure if and how can be done for a specific connection only.

Thanks for any suggestions