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).
Incorrect string value \xE9
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:
Clearly, the issue comes from the fact that the
Tagcolumn of thecmsTagstable is usingutf8_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
xmlcolumn ofcmscontentxmlis usinglatin1_swedish_ci(maybe the infra team where I work changed it, I don't know).Could I have some guidance please?
is working on a reply...