I'm reading up on internationalizing applications...WOW! What a mouth full.
If everyone just assimilated with the American way of life things would be much easier.
Anyways...collation...I finally understand what that option means in phpMyAdmin...
At least I assume it means that MySQL will handle collation for my users automatically?
Only how does MySQL know to sort the results according to locale? For instance, apparently identical lists will be sorted differently by someone in Sweden as opposed to someone in Germany. I'm not sure what language it was, but as an English speaker I would expect to see an accented "A" in the A's but some cultures do not wrk this way.
Does using MySQL take care of this caveat? How does it know what locale my user is in? How do I tell it what locale my user is in?