Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

请问下字段为json的内容,如何解析出来呢 #124

Open
yuxicun opened this issue Oct 10, 2023 · 0 comments
Open

请问下字段为json的内容,如何解析出来呢 #124

yuxicun opened this issue Oct 10, 2023 · 0 comments

Comments

@yuxicun
Copy link

yuxicun commented Oct 10, 2023

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})

请问怎么还原出原来文本

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant