New database character issues (3 posts)

  1. Ray Monohan
    Posted 3 years ago #

    We put stuff into a new cloud database today and now I'm seeing strange characters.


    How do I fix?

  2. Ray Monohan
    Posted 3 years ago #

    Example ’

  3. michael.mariart
    Posted 3 years ago #

    This normally happens when the character encoding ('colation' in MySQL terms) is set differently on the two databases. When you are storing and retriving data from the same system it's not a problem because what goes in is what comes out, but if the tables colation changes then it can treat the data differently depending on what's set.

    What I'd suggest doing is looking at what is set for the colation in your tables on the old DB and the new DB, and make sure that the new DB matches the old one.

Topic Closed

This topic has been closed to new replies.

About this Topic