Re: Strange behavior between mysql versions with binary
Posted by:
Rick James
Date: April 28, 2012 01:46PM
Probably mangled the charsets in the dump or reload.
See
http://mysql.rjweb.org/doc.php/memory
Try to get the HEX() for the column that is matching (or not) from each machine. I expect them to be different.
Also, what charset is your API using? Also run this from some client:
select hex(binary 'Précaution'), length(binary 'Précaution');
The second column will say 10 for latin1 and 11 for utf8.
Subject
Written By
Posted
Re: Strange behavior between mysql versions with binary
April 28, 2012 01:46PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.