Last_SQL_Errno: 1366

轩辕阁

主库上面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;
　　但是这样一修改，
　　然后从库上面就不会报错了，但是却破坏了数据库字符集的统一性，有一定的隐患。