Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at

  • ssougnez 86 posts 290 karma points c-trib
    Apr 15, 2019 @ 11:50

    Incorrect string value \xE9


    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?

Please Sign in or register to post replies

Write your reply to: