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
7558
October 26, 2011 10:11PM
2783
October 27, 2011 08:34PM
2783
October 28, 2011 09:51AM
Re: Illegal mix of collation during replication
3020
October 29, 2011 01:39PM
Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.
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.