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?
This is a companion discussion topic for the original entry at https://our.umbraco.com/forum/96830-incorrect-string-value-xe9