Answers.Body: <p>I'm guessing it's whether the particular sort implementation in each case is configured to be UTF8-aware. If I order by name asc in MySQL, I see Côte d'Ivoire just after Costa Rica. If I look at a hex dump of the actual bytes, ô expands to EF BF BD, which will appear long after o (6F) and even z if the sort isn't UTF8-aware. Have a look at the localisation configuration of PHP on your servers.</p>
  
  <p>Sort order can be affected by cultural differences as you suspected, eg Swedish vs German at <a href="https://sgehrig.wordpress.com/2008/09/24/on-how-to-sort-an-array-of-utf-8-strings/" rel="nofollow">https://sgehrig.wordpress.com/2008/09/24/on-how-to-sort-an-array-of-utf-8-strings/</a></p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-10-07T20:38:39.237Z
Answers.LastActivityDate: 2015-10-07T20:38:39.237Z
Answers.UserDisplayName: DaveFF
Body: <p>I've noticed that on some installs of CiviCRM 4.6 that I'm working with, when using a profile that includes the Country field, for an address for example, I'm seeing that Côte d'Ivoire is listed after Czech Republic, when it should be listed just after Costa Rica.</p>
  
  <p>The order in the database table is correct, so what's causing the listing order to change? I can't reproduce this on the demo site, and the sites that I am seeing it on are using a different default language (English UK as opposed to US English). Might that be a cause of the issue? Any clues as to how to fix this minor yet irritating issue very welcome.</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-10-07T12:14:18.403Z
Comments.Text: Just tested again on the demo site, and if I change the default language there to UK English, the sort order changes as well, and Côte d'Ivoire moves position in the list to follow the Czech Republic. Deliberate outcome of cultural differences in sorting/listing, or a bug?
Comments.UserDisplayName: Graham
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-10-07T14:55:37.370Z
Comments.Text: @DaveFF I think you should make your comment an answer.
Comments.UserDisplayName: Coleman
Tags: <localisation>
Title: A small problem with the Côte d'Ivoire
ThreadText: # A small problem with the Côte d'Ivoire
  
  (Asked by: username_0 on 2015-10-07)
  
  I've noticed that on some installs of CiviCRM 4.6 that I'm working with, when using a profile that includes the Country field, for an address for example, I'm seeing that Côte d'Ivoire is listed after Czech Republic, when it should be listed just after Costa Rica.
  
  The order in the database table is correct, so what's causing the listing order to change? I can't reproduce this on the demo site, and the sites that I am seeing it on are using a different default language (English UK as opposed to US English). Might that be a cause of the issue? Any clues as to how to fix this minor yet irritating issue very welcome.
  
  **Tags:** localisation
  
  > **Comments:**
  > **username_0**: Just tested again on the demo site, and if I change the default language there to UK English, the sort order changes as well, and Côte d'Ivoire moves position in the list to follow the Czech Republic. Deliberate outcome of cultural differences in sorting/listing, or a bug?  
  > **username_1**: @username_2 I think you should make your comment an answer.  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_2 on 2015-10-07. Score: 2 | Accepted answer
  
  I'm guessing it's whether the particular sort implementation in each case is configured to be UTF8-aware. If I order by name asc in MySQL, I see Côte d'Ivoire just after Costa Rica. If I look at a hex dump of the actual bytes, ô expands to EF BF BD, which will appear long after o (6F) and even z if the sort isn't UTF8-aware. Have a look at the localisation configuration of PHP on your servers.
  
  Sort order can be affected by cultural differences as you suspected, eg Swedish vs German at <https://sgehrig.wordpress.com/2008/09/24/on-how-to-sort-an-array-of-utf-8-strings/>
  
  
  ---
  
  