Hello,

we are using Umbraco with mysql and when we try to save a page with some tags that contains diacritics (in french), we get the error:

MySql.Data.MySqlClient.MySqlException (0x80004005): Incorrect string value: '\xE9' for column 'Tag' at row 1

Clearly, the issue comes from the fact that the Tag column of the cmsTags table is using utf8_general_ci.

While the source of the error is obvious, the resolution is not that obvious to me. What am I supposed to do to fix it?

Do I have to change something in the database of Umbraco (doesn't sound like a best practice) or is it an up to Umbraco to fix this?

Note that I don't have the issue with the content of the page as the xml column of cmscontentxml is using latin1_swedish_ci (maybe the infra team where I work changed it, I don't know).

Could I have some guidance please?