Sign in Register
Copied to clipboard

Flag this post as spam?

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


  • Boby 20 posts 42 karma points
    May 05, 2010 @ 20:54
    Boby
    0

    Unable to publish document with certain characters - "" for example - Umbraco 4.0.3 and MySQL 5

    I'm getting the below error when trying to publish a document with the "œ" character in it. Tried changing MySql  database character set to latin1 and utf8, but that didn't solve the problem.

    I'm able to save the document with these characters in, but when I try to publish, the exception occurs.

    This is the sentence that causes it "....les plus étonnantes œuvres d'ar..."

    Incorrect string value: '\xC2\x9Cuvre...' for column 'DATANTEXT' at row 1

    Exception Details: MySql.Data.MySqlClient.MySqlException: Incorrect string value: '\xC2\x9Cuvre...' for column 'DATANTEXT' at row 1

    Stack Trace:

    [MySqlException (0x80004005): Incorrect string value: '\xC2\x9Cuvre...' for column 'DATANTEXT' at row 1]
       MySql.Data.MySqlClient.MySqlStream.OpenPacket() +280
       MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId) +59
       MySql.Data.MySqlClient.MySqlDataReader.GetResultSet() +62

     

    Anyone know what's wrong or what am I doing wrong?

    Thanks,
    Boby

    Copy Link
  • Mark Derman 3 posts 23 karma points
    Aug 30, 2010 @ 12:17
    Mark Derman
    0

    I'm having the same problem.

    Did you find a solution?

    I'll let you know if I do.

    Cheers,

    Mark

     

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft