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.

Options: ReplyQuote


Subject
Views
Written By
Posted
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.