Forexcom typical spreads
For example, with a binary setting, the character C in Cindy, Chad, and Clara represents the same letter C. So the letter c in Chad is different than the letter C in Cindy and Clara. Using a binary sort for ASCII is accurate and fast because the binary codes for ASCII characters reflect their linguistic order. When data in multiple languages is stored in the database, you may want applications to sort the data returned from a SELECT.
ORDER BY statement according to different sort sequences depending on the language.