MySQL Forums
Forum List  »  General

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.

Options: ReplyQuote




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.