Re: ENCODE() on MySQL 5.0 differs from 5.5+
Posted by: Rick James
Date: November 13, 2012 09:05AM

What characters are in the string you are encoding? If you have accented letters as opposed to ascii characters, you might have the source string encoded differently. The 5.0 default CHARACTER SET was latin1, the 5.5 may be utf8.

For further discussion, please provide an example of an input string and HEX(ENCODE(..., ...)) on both systems.

Options: ReplyQuote


Subject
Written By
Posted
Re: ENCODE() on MySQL 5.0 differs from 5.5+
November 13, 2012 09:05AM


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.