zeng8280 2020-09-29 09:04 采纳率: 0%
浏览 123
已结题

json 格式的字典 存入mysql的blob 格式后 怎么用python 进行解码 读取呀

为了存储方便， 我 将mysql 某一列 转存为json 格式，然后存入mysql的 blob结构里。 之后进行某查询的时候，将结果用python读取的时候 成了这样的 有会解码的朋友吗？ 

'risklevellowscorenumberInt5itemidnumberInt3216084itemnameu8eabu4efdu8bc1u547du4e2du4e2du98ceu9669u5173u6ce8u540du5355groupu98ceu9669u4fe1u606fu626bu63cfrisklevellowscorenumberInt2itemidnumberInt3216118itemnameu624bu673au53f7u547du4e2du4f4eu98ceu9669u5173u6ce8u540du5355groupu98ceu9669u4fe1u606fu626bu63cfrisklevelmediumscorenumberInt1itemdetailplatformdetailu4e00u822cu6d88u8d39u5206u671fu5e73u53f01platformcountnumberInt1typeplatformdetailitemidnumberInt33575984itemnameu8fd16u4e2au6708u5185u7533u8bf7u4ebau5728u591au4e2au5e73u53f0u7533u8bf7u6b21u6570groupu591au5e73u53f0u501fu8d37u7533u8bf7u68c0u6d4brisklevellowscorenumberInt3itemdetailplatformdetaildimensioncountnumberInt1detailu5927u578bu6d88u8d39u91d1u878du516cu53f81dimensionu501fu6b3eu4ebau624bu673au8be6u60c5countnumberInt3detailu4e00u822cu6d88u8d39u5206u671fu5e73u53f01u5927u578bu6d88u8d39u91d1u878du516cu53f82dimensionu501fu6b3eu4ebau8eabu4efdu8bc1u8be6u60c5platformdetailu4e00u822cu6d88u8d39u5206u671fu5e73u53f01u5927u578bu6d88u8d39u91d1u878du516cu53f82platformcountnumberInt3typeplatformdetailitemidnumberInt33575994itemnameu8fd112u4e2au6708u5185u7533u8bf7u4ebau5728u591au4e2au5e73u53f0u7533u8bf7u6b21u6570groupu591au5e73u53f0u501fu8d37u7533u8bf7u68c0u6d4brisklevellowscorenumberInt6itemdetailplatformdetaildimensioncountnumberInt5detailu4e00u822cu6d88u8d39u5206u671fu5e73u53f01u5c0fu989du8d37u6b3eu516cu53f81P2Pu7f51u8d371u5927u578bu6d88u8d39u91d1u878du516cu53f82dimensionu501fu6b3eu4ebau624bu673au8be6u60c5countnumberInt9detailu4e00u822cu6d88u8d39u5206u671fu5e73u53f02u94f6u884cu6d88u8d39u91d1u878du516cu53f81u4fe1u7528u5361u4e2du5fc31u5c0fu989du8d37u6b3eu516cu53f81P2Pu7f51u8d372u5927u578bu6d88u8d39u91d1u878du516cu53f82dimensionu501fu6b3eu4ebau8eabu4efdu8bc1u8be6u60c5platformdetailu4e00u822cu6d88u8d39u5206u671fu5e73u53f02u94f6u884cu6d88u8d39u91d1u878du516cu53f81u4fe1u7528u5361u4e2du5fc31u5c0fu989du8d37u6b3eu516cu53f81P2Pu7f51u8d372u5927u578bu6d88u8d39u91d1u878du516cu53f82platformcountnumberInt9typeplatformdetailitemidnumberInt33576004itemnameu8fd124u4e2au6708u5185u7533u8bf7u4ebau5728u591au4e2au5e73u53f0u7533u8bf7u6b21u6570groupu591au5e73u53f0u501fu8d37u7533u8bf7u68c0u6d4brisklevellowscorenumberInt2itemdetailplatformdetaildimensioncountnumberInt7detailu4e00u822cu6d88u8d39u5206u671fu5e73u53f02u76f4u9500u94f6u884c1u5c0fu989du8d37u6b3eu516cu53f81P2Pu7f51u8d371u5927u578bu6d88u8d39u91d1u878du516cu53f82dimensionu501fu6b3eu4ebau624bu673au8be6u60c5countnumberInt14detailu4e00u822cu6d88u8d39u5206u671fu5e73u53f03u5927u6570u636eu91d1u878d1u94f6u884cu6d88u8d39u91d1u878du516cu53f82u76f4u9500u94f6u884c1u4fe1u7528u5361u4e2du5fc31u5c0fu989du8d37u6b3eu516cu53f82P2Pu7f51u8d372u5927u578bu6d88u8d39u91d1u878du516cu53f82dimensionu501fu6b3eu4ebau8eabu4efdu8bc1u8be6u60c5platformdetailu4e00u822cu6d88u8d39u5206u671fu5e73u53f03u5927u6570u636eu91d1u878d1u94f6u884cu6d88u8d39u91d1u878du516cu53f82u76f4u9500u94f6u884c1u4fe1u7528u5361u4e2du5fc31u5c0fu989du8d37u6b3eu516cu53f82P2Pu7f51u8d372u5927u578bu6d88u8d39u91d1u878du516cu53f82platformcountnumberInt14typeplatformdetailitemidnumberInt33576014itemnameu8fd160u4e2au6708u5185u7533u8bf7u4ebau5728u591au4e2au5e73u53f0u7533u8bf7u6b21u6570groupu591au5e73u53f0u501fu8d37u7533u8bf7u68c0u6d4'
  • 写回答

37条回答 默认 最新

  • sinJack 2020-09-29 09:18
    关注

    你直接在mysql客户端查询，数据是这样的吗

    评论

报告相同问题？

悬赏问题

  • ¥30 模拟电路 logisim
  • ¥15 PVE8.2.7无法成功使用a5000的vGPU，什么原因
  • ¥15 is not in the mmseg::model registry。报错，模型注册表找不到自定义模块。
  • ¥15 安装quartus II18.1时弹出此error，怎么解决？
  • ¥15 keil官网下载psn序列号在哪
  • ¥15 想用adb命令做一个通话软件，播放录音
  • ¥30 Pytorch深度学习服务器跑不通问题解决？
  • ¥15 部分客户订单定位有误的问题
  • ¥15 如何在maya程序中利用python编写领子和褶裥的模型的方法
  • ¥15 Bug traq 数据包 大概什么价