I'm trying to compare master and slave using mysqldbcompare utility, but observed that it's getting failed and in compare result its not showing difference rows.so I manually compared tables and observed that there is some special character in master is making this difference in slave as '?'. Please let me know how can I avoid this issue.
below is the sample record from master and slave.
Master:
mysql> select description from mp_prod.devices where id=22672\G;
*************************** 1. row ***************************
description: Amanda iPad -
1 row in set (0.00 sec)
slave :
mysql> select description from mp_prod.devices where id=22672\G;
*************************** 1. row ***************************
description: Amanda iPad - ?
