Answers.Body: <p>It was my table and column collation settings. Both were latin1_swedish_ci. Evidently this collation does not support the weirdo characters those foreigners use ;^).</p>
  
  <p>I rolled the database back using the backup I made (ALWAYS glad I make a backup before upgrading!!!). Then using phpMyAdmin I edited the table civicrm_state_province to have a collation of utf8_general_ci. I then re-upgraded the civicrm installation and all went well.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-05-02T19:04:14.560Z
Answers.LastActivityDate: 2019-05-02T19:04:14.560Z
Answers.UserDisplayName: Jay Edgar
Body: <p>I'm failing because mysql doesn't like characters in a city name:</p>
  
  <p>UPDATE civicrm_state_province INNER JOIN civicrm_country ON civicrm_state_province.country_id = civicrm_country.id SET civicrm_state_province.name = 'dolnośląskie' WHERE iso_code = 'PL' AND abbreviation = 'DS'</p>
  
  <p>If fails with "ncorrect string value: '\xC5\x9Bl\xC4\x85s...' for column 'name' at row 3]"</p>
  
  <p>Running civicrm under Joomla 3.9.5.</p>
  
  <p>Solution below.</p>
  
Tags: <upgrade><database>
Title: Upgrade from 5.11.0 to 5.12. failing database update - solution found
ThreadText: # Upgrade from 5.11.0 to 5.12. failing database update - solution found
  
  (Asked by: username_0 on 2019-05-02)
  
  I'm failing because mysql doesn't like characters in a city name:
  
  UPDATE civicrm\_state\_province INNER JOIN civicrm\_country ON civicrm\_state\_province.country\_id = civicrm\_country.id SET civicrm\_state\_province.name = 'dolnośląskie' WHERE iso\_code = 'PL' AND abbreviation = 'DS'
  
  If fails with "ncorrect string value: '\xC5\x9Bl\xC4\x85s...' for column 'name' at row 3]"
  
  Running civicrm under Joomla 3.9.5.
  
  Solution below.
  
  **Tags:** upgrade, database
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_0 on 2019-05-02. Score: 1
  
  It was my table and column collation settings. Both were latin1\_swedish\_ci. Evidently this collation does not support the weirdo characters those foreigners use ;^).
  
  I rolled the database back using the backup I made (ALWAYS glad I make a backup before upgrading!!!). Then using phpMyAdmin I edited the table civicrm\_state\_province to have a collation of utf8\_general\_ci. I then re-upgraded the civicrm installation and all went well.
  
  
  ---
  
  