主库上面insert没事,从库上面一直报错
Last_SQL_Errno: 1366
               Last_SQL_Error: Error 'Incorrect string value: '\xB2\xBD\xD6\xE8\xA3\xBA...' for column 'VALUE_STR' at row 1' on query. Default database: 'bgkettle'. Query: 'INSERT INTO R_NOTE (ID_NOTE, VALUE_STR, GUI_LOCATION_X, GUI_LOCATION_Y, GUI_LOCATION_WIDTH, GUI_LOCATION_HEIGHT, FONT_NAME, FONT_SIZE, FONT_BOLD, FONT_ITALIC, FONT_COLOR_RED, FONT_COLOR_GREEN, FONT_COLOR_BLUE, FONT_BACK_GROUND_COLOR_RED, FONT_BACK_GROUND_COLOR_GREEN, FONT_BACK_GROUND_COLOR_BLUE, FONT_BORDER_COLOR_RED, FONT_BORDER_COLOR_GREEN, FONT_BORDER_COLOR_BLUE, DRAW_SHADOW) VALUES ( 1,  0xB2BDD6E8A3BA0A0931A1A2B4D3BBB7BEB3B1E4C1BFD6D0BBF1C8A1B1BEB4CECAB9D3C3B5C4CAB1BCE4A3A8BEABC8B7B5BDCCECA3A9A3ACC0FDC8E7A3BA323031322D30332D32322030303A30303A30300A0932A1A2BDABCAB1BCE4D4F6BCD33234D0A1CAB1A3ACC7D0BBBBB3C9CFC2D2BBCCECA3A8323031322D30332D32332030303A30303A3030A3A90A0933A1A2D0B4C8EBCAFDBEDDBFE23A7570646174652060626765746C602E6062675F65746C5F74696D656020736574206C6173745F74696D653D27323031322D30332D32332030303A30303A303027207768657265206170703D31,  99,  201,  584,  70, 
1 row in set (0.00 sec)
检查了主从所有字符集配置,都是utf8;后来google下,借鉴了别人的方案,搞定了。
解决方案:
alter table bgkettle.R_NOTE modify `VALUE_STR` mediumtext  character set gbk; 

但是这样一修改,
然后从库上面就不会报错了,但是却破坏了数据库字符集的统一性,有一定的隐患。