Open yuxicun opened 9 months ago
json字段类型的值，在binlog中是 ----+----------+-------+--------------+--------------+--------------+--------------+-----------+-----------
2023-10-10 10:15:25.371 INFO 9876 --- [ool-10-thread-1] com.scy.web.mysql.MysqlListener : 2-TableMapEventData{tableId=106, database='springboot_jpa', table='t_demo', columnTypes=15, 18, 18, 18, -10, -4, -11, 15, 3, 15, 4, 19, -4, columnMetadata=80, 6, 6, 6, 532, 4, 4, 1020, 0, 1020, 4, 0, 1, columnNullability={1, 2, 3, 4, 5, 6, 7, 9, 10, 11, 12}, eventMetadata=TableMapEventMetadata{signedness={}, defaultCharset=45, charsetCollations=null, columnCharsets=null, columnNames=id, create_time, update_time, birth_day, cash_val, content, json_val, title, sex, sex_str, sort, dd, qq, setStrValues=null, enumStrValues=null, geometryTypes=null, simplePrimaryKeys=0, primaryKeysWithPrefix=null, enumAndSetDefaultCharset=null, enumAndSetColumnCharsets=null,visibility={0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12}}} 2023-10-10 10:15:25.388 INFO 9876 --- [ool-10-thread-1] com.scy.web.mysql.DataHandler : b-[0, 5, 0, -48, 0, 39, 0, 3, 0, 42, 0, 5, 0, 47, 0, 7, 0, 54, 0, 7, 0, 61, 0, 8, 0, 5, 0, 0, 12, 69, 0, 11, -98, 0, 12, -90, 0, 10, -56, 0, 115, 101, 120, 116, 105, 116, 108, 101, 99, 97, 115, 104, 86, 97, 108, 99, 111, 110, 116, 101, 110, 116, 98, 105, 114, 116, 104, 68, 97, 121, 88, 84, 97, 120, 112, 97, 121, 101, 114, 32, 100, 105, 114, 101, 99, 116, 108, 121, 32, 101, 120, 112, 108, 97, 110, 97, 116, 105, 111, 110, 32, 112, 97, 114, 101, 110, 116, 32, 118, 105, 115, 105, 111, 110, 32, 105, 110, 99, 114, 101, 97, 115, 101, 32, 99, 111, 117, 114, 115, 101, 32, 116, 114, 97, 105, 110, 105, 110, 103, 32, 105, 109, 112, 108, 105, 99, 97, 116, 105, 111, 110, 32, 116, 114, 97, 103, 101, 100, 121, 72, -31, 122, 20, -82, -121, 54, 64, 33, -24, -65, -103, -28, -72, -86, -28, -72, -118, -26, -105, -84, -26, -128, -69, -26, -104, -81, -26, -116, -121, -27, -81, -68, -25, -123, -92, -25, -86, -111, -29, -128, -126, -74, -106, 34, 38, -119, 1, 0, 0] false 处理json��,{b�W�j�UjW(�ק������t�Ɩ�z�b��-�'��V�jب���z{o�Ȩ�)ܭ�y�.�ǭ����x"��bq�b�{kj��|� 2023-10-10 10:15:25.402 INFO 9876 --- [ool-10-thread-1] com.scy.web.mysql.DataHandler : b-[0, 5, 0, -48, 0, 39, 0, 3, 0, 42, 0, 5, 0, 47, 0, 7, 0, 54, 0, 7, 0, 61, 0, 8, 0, 5, 0, 0, 12, 69, 0, 11, -98, 0, 12, -90, 0, 10, -56, 0, 115, 101, 120, 116, 105, 116, 108, 101, 99, 97, 115, 104, 86, 97, 108, 99, 111, 110, 116, 101, 110, 116, 98, 105, 114, 116, 104, 68, 97, 121, 88, 84, 97, 120, 112, 97, 121, 101, 114, 32, 100, 105, 114, 101, 99, 116, 108, 121, 32, 101, 120, 112, 108, 97, 110, 97, 116, 105, 111, 110, 32, 112, 97, 114, 101, 110, 116, 32, 118, 105, 115, 105, 111, 110, 32, 105, 110, 99, 114, 101, 97, 115, 101, 32, 99, 111, 117, 114, 115, 101, 32, 116, 114, 97, 105, 110, 105, 110, 103, 32, 105, 109, 112, 108, 105, 99, 97, 116, 105, 111, 110, 32, 116, 114, 97, 103, 101, 100, 121, 72, -31, 122, 20, -82, -121, 54, 64, 33, -24, -65, -103, -28, -72, -86, -28, -72, -118, -26, -105, -84, -26, -128, -69, -26, -104, -81, -26, -116, -121, -27, -81, -68, -25, -123, -92, -25, -86, -111, -29, -128, -126, -74, -106, 34, 38, -119, 1, 0, 0] false 处理json��,{b�W�j�UjW(�ק������t�Ɩ�z�b��-�'��V�jب���z{o�Ȩ�)ܭ�y�.�ǭ����x"��bq�b�{kj��|� 2023-10-10 10:15:25.403 INFO 9876 --- [ool-10-thread-1] com.scy.web.mysql.DataHandler : 更新了数据: DataInfo(dataBase=springboot_jpa, tableName=t_demo, dataRow={id=1676576444857589760, create_time=2023-07-05 20:59:08, update_time=2023-07-05 20:59:08, birth_day=2023-07-05 20:59:08, cash_val=22.53, content=这个上旬总是指导煤窑。, json_val=[0,5,0,-48,0,39,0,3,0,42,0,5,0,47,0,7,0,54,0,7,0,61,0,8,0,5,0,0,12,69,0,11,-98,0,12,-90,0,10,-56,0,115,101,120,116,105,116,108,101,99,97,115,104,86,97,108,99,111,110,116,101,110,116,98,105,114,116,104,68,97,121,88,84,97,120,112,97,121,101,114,32,100,105,114,101,99,116,108,121,32,101,120,112,108,97,110,97,116,105,111,110,32,112,97,114,101,110,116,32,118,105,115,105,111,110,32,105,110,99,114,101,97,115,101,32,99,111,117,114,115,101,32,116,114,97,105,110,105,110,103,32,105,109,112,108,105,99,97,116,105,111,110,32,116,114,97,103,101,100,121,72,-31,122,20,-82,-121,54,64,33,-24,-65,-103,-28,-72,-86,-28,-72,-118,-26,-105,-84,-26,-128,-69,-26,-104,-81,-26,-116,-121,-27,-81,-68,-25,-123,-92,-25,-86,-111,-29,-128,-126,-74,-106,34,38,-119,1,0,0], title=Taxpayer directly explanation parent vision increase course training implication tragedy, sex=0, sex_str=null, sort=0.0, dd=null, qq=null}) DataInfo(dataBase=springboot_jpa, tableName=t_demo, dataRow={id=1676576444857589760, create_time=2023-07-22 20:59:08, update_time=2023-07-05 20:59:08, birth_day=2023-07-05 20:59:08, cash_val=22.53, content=这个上旬总是指导煤窑。, json_val=[0,5,0,-48,0,39,0,3,0,42,0,5,0,47,0,7,0,54,0,7,0,61,0,8,0,5,0,0,12,69,0,11,-98,0,12,-90,0,10,-56,0,115,101,120,116,105,116,108,101,99,97,115,104,86,97,108,99,111,110,116,101,110,116,98,105,114,116,104,68,97,121,88,84,97,120,112,97,121,101,114,32,100,105,114,101,99,116,108,121,32,101,120,112,108,97,110,97,116,105,111,110,32,112,97,114,101,110,116,32,118,105,115,105,111,110,32,105,110,99,114,101,97,115,101,32,99,111,117,114,115,101,32,116,114,97,105,110,105,110,103,32,105,109,112,108,105,99,97,116,105,111,110,32,116,114,97,103,101,100,121,72,-31,122,20,-82,-121,54,64,33,-24,-65,-103,-28,-72,-86,-28,-72,-118,-26,-105,-84,-26,-128,-69,-26,-104,-81,-26,-116,-121,-27,-81,-68,-25,-123,-92,-25,-86,-111,-29,-128,-126,-74,-106,34,38,-119,1,0,0], title=Taxpayer directly explanation parent vision increase course training implication tragedy, sex=0, sex_str=null, sort=0.0, dd=null, qq=null})
请问怎么还原出原来文本
json字段类型的值，在binlog中是 ----+----------+-------+--------------+--------------+--------------+--------------+-----------+-----------
2023-10-10 10:15:25.371 INFO 9876 --- [ool-10-thread-1] com.scy.web.mysql.MysqlListener : 2-TableMapEventData{tableId=106, database='springboot_jpa', table='t_demo', columnTypes=15, 18, 18, 18, -10, -4, -11, 15, 3, 15, 4, 19, -4, columnMetadata=80, 6, 6, 6, 532, 4, 4, 1020, 0, 1020, 4, 0, 1, columnNullability={1, 2, 3, 4, 5, 6, 7, 9, 10, 11, 12}, eventMetadata=TableMapEventMetadata{signedness={}, defaultCharset=45, charsetCollations=null, columnCharsets=null, columnNames=id, create_time, update_time, birth_day, cash_val, content, json_val, title, sex, sex_str, sort, dd, qq, setStrValues=null, enumStrValues=null, geometryTypes=null, simplePrimaryKeys=0, primaryKeysWithPrefix=null, enumAndSetDefaultCharset=null, enumAndSetColumnCharsets=null,visibility={0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12}}} 2023-10-10 10:15:25.388 INFO 9876 --- [ool-10-thread-1] com.scy.web.mysql.DataHandler : b-[0, 5, 0, -48, 0, 39, 0, 3, 0, 42, 0, 5, 0, 47, 0, 7, 0, 54, 0, 7, 0, 61, 0, 8, 0, 5, 0, 0, 12, 69, 0, 11, -98, 0, 12, -90, 0, 10, -56, 0, 115, 101, 120, 116, 105, 116, 108, 101, 99, 97, 115, 104, 86, 97, 108, 99, 111, 110, 116, 101, 110, 116, 98, 105, 114, 116, 104, 68, 97, 121, 88, 84, 97, 120, 112, 97, 121, 101, 114, 32, 100, 105, 114, 101, 99, 116, 108, 121, 32, 101, 120, 112, 108, 97, 110, 97, 116, 105, 111, 110, 32, 112, 97, 114, 101, 110, 116, 32, 118, 105, 115, 105, 111, 110, 32, 105, 110, 99, 114, 101, 97, 115, 101, 32, 99, 111, 117, 114, 115, 101, 32, 116, 114, 97, 105, 110, 105, 110, 103, 32, 105, 109, 112, 108, 105, 99, 97, 116, 105, 111, 110, 32, 116, 114, 97, 103, 101, 100, 121, 72, -31, 122, 20, -82, -121, 54, 64, 33, -24, -65, -103, -28, -72, -86, -28, -72, -118, -26, -105, -84, -26, -128, -69, -26, -104, -81, -26, -116, -121, -27, -81, -68, -25, -123, -92, -25, -86, -111, -29, -128, -126, -74, -106, 34, 38, -119, 1, 0, 0] false 处理json��,{b�W�j�UjW(�ק������t�Ɩ�z�b��-�'��V�jب���z{o�Ȩ�)ܭ�y�.�ǭ����x"��bq�b�{kj��|� 2023-10-10 10:15:25.402 INFO 9876 --- [ool-10-thread-1] com.scy.web.mysql.DataHandler : b-[0, 5, 0, -48, 0, 39, 0, 3, 0, 42, 0, 5, 0, 47, 0, 7, 0, 54, 0, 7, 0, 61, 0, 8, 0, 5, 0, 0, 12, 69, 0, 11, -98, 0, 12, -90, 0, 10, -56, 0, 115, 101, 120, 116, 105, 116, 108, 101, 99, 97, 115, 104, 86, 97, 108, 99, 111, 110, 116, 101, 110, 116, 98, 105, 114, 116, 104, 68, 97, 121, 88, 84, 97, 120, 112, 97, 121, 101, 114, 32, 100, 105, 114, 101, 99, 116, 108, 121, 32, 101, 120, 112, 108, 97, 110, 97, 116, 105, 111, 110, 32, 112, 97, 114, 101, 110, 116, 32, 118, 105, 115, 105, 111, 110, 32, 105, 110, 99, 114, 101, 97, 115, 101, 32, 99, 111, 117, 114, 115, 101, 32, 116, 114, 97, 105, 110, 105, 110, 103, 32, 105, 109, 112, 108, 105, 99, 97, 116, 105, 111, 110, 32, 116, 114, 97, 103, 101, 100, 121, 72, -31, 122, 20, -82, -121, 54, 64, 33, -24, -65, -103, -28, -72, -86, -28, -72, -118, -26, -105, -84, -26, -128, -69, -26, -104, -81, -26, -116, -121, -27, -81, -68, -25, -123, -92, -25, -86, -111, -29, -128, -126, -74, -106, 34, 38, -119, 1, 0, 0] false 处理json��,{b�W�j�UjW(�ק������t�Ɩ�z�b��-�'��V�jب���z{o�Ȩ�)ܭ�y�.�ǭ����x"��bq�b�{kj��|� 2023-10-10 10:15:25.403 INFO 9876 --- [ool-10-thread-1] com.scy.web.mysql.DataHandler : 更新了数据: DataInfo(dataBase=springboot_jpa, tableName=t_demo, dataRow={id=1676576444857589760, create_time=2023-07-05 20:59:08, update_time=2023-07-05 20:59:08, birth_day=2023-07-05 20:59:08, cash_val=22.53, content=这个上旬总是指导煤窑。, json_val=[0,5,0,-48,0,39,0,3,0,42,0,5,0,47,0,7,0,54,0,7,0,61,0,8,0,5,0,0,12,69,0,11,-98,0,12,-90,0,10,-56,0,115,101,120,116,105,116,108,101,99,97,115,104,86,97,108,99,111,110,116,101,110,116,98,105,114,116,104,68,97,121,88,84,97,120,112,97,121,101,114,32,100,105,114,101,99,116,108,121,32,101,120,112,108,97,110,97,116,105,111,110,32,112,97,114,101,110,116,32,118,105,115,105,111,110,32,105,110,99,114,101,97,115,101,32,99,111,117,114,115,101,32,116,114,97,105,110,105,110,103,32,105,109,112,108,105,99,97,116,105,111,110,32,116,114,97,103,101,100,121,72,-31,122,20,-82,-121,54,64,33,-24,-65,-103,-28,-72,-86,-28,-72,-118,-26,-105,-84,-26,-128,-69,-26,-104,-81,-26,-116,-121,-27,-81,-68,-25,-123,-92,-25,-86,-111,-29,-128,-126,-74,-106,34,38,-119,1,0,0], title=Taxpayer directly explanation parent vision increase course training implication tragedy, sex=0, sex_str=null, sort=0.0, dd=null, qq=null}) DataInfo(dataBase=springboot_jpa, tableName=t_demo, dataRow={id=1676576444857589760, create_time=2023-07-22 20:59:08, update_time=2023-07-05 20:59:08, birth_day=2023-07-05 20:59:08, cash_val=22.53, content=这个上旬总是指导煤窑。, json_val=[0,5,0,-48,0,39,0,3,0,42,0,5,0,47,0,7,0,54,0,7,0,61,0,8,0,5,0,0,12,69,0,11,-98,0,12,-90,0,10,-56,0,115,101,120,116,105,116,108,101,99,97,115,104,86,97,108,99,111,110,116,101,110,116,98,105,114,116,104,68,97,121,88,84,97,120,112,97,121,101,114,32,100,105,114,101,99,116,108,121,32,101,120,112,108,97,110,97,116,105,111,110,32,112,97,114,101,110,116,32,118,105,115,105,111,110,32,105,110,99,114,101,97,115,101,32,99,111,117,114,115,101,32,116,114,97,105,110,105,110,103,32,105,109,112,108,105,99,97,116,105,111,110,32,116,114,97,103,101,100,121,72,-31,122,20,-82,-121,54,64,33,-24,-65,-103,-28,-72,-86,-28,-72,-118,-26,-105,-84,-26,-128,-69,-26,-104,-81,-26,-116,-121,-27,-81,-68,-25,-123,-92,-25,-86,-111,-29,-128,-126,-74,-106,34,38,-119,1,0,0], title=Taxpayer directly explanation parent vision increase course training implication tragedy, sex=0, sex_str=null, sort=0.0, dd=null, qq=null})
请问怎么还原出原来文本