Re: Illegal mix of collation during replication
Posted by:
Rick James
Date: October 29, 2011 01:39PM
Quote
The INET_NTOA() return value contains only ASCII characters, and this function now returns a character string with the connection character set and collation rather than a binary string.
--
http://dev.mysql.com/doc/refman/5.5/en/news-5-5-3.html
Add a CAST or CONVERT if you need to avoid the issue.
Also, it would be better to filter the data before putting it into the table, rather than checking in the SELECT.
Are you ready for IPv6? It is upon us. I recommend VARBINARY(39) for storing IPv6 strings.
Subject
Views
Written By
Posted
7531
October 26, 2011 10:11PM
2769
October 27, 2011 08:34PM
2772
October 28, 2011 09:51AM
Re: Illegal mix of collation during replication
3007
October 29, 2011 01:39PM
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.