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.

1 Answer 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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.