1、在navicat中显示的样子,中文都正常 2、在设计器里,中文全部变成乱码 3、是因为什么原因?帆软之前做别的报表中文都正常显示?是我写的语句的问题吗?4、我写的语句是: SELECT zswsxz,zswid, case when JSON_VALID(zswsxz) then replace(JSON_EXTRACT(zswsxz,'$.SWID'),"\"","") else null end as 'SWID', case when JSON_VALID(zswsxz) then replace(JSON_EXTRACT(zswsxz,'$.XH'),"\"","") else null end as 'XH', case when JSON_VALID(zswsxz) then replace(JSON_EXTRACT(zswsxz,'$.JDDZ'),"\"","") else null end as 'JDDZ', case when JSON_VALID(zswsxz) then replace(JSON_EXTRACT(zswsxz,'$.PBZRL'),"\"","") else null end as 'PBZRL', case when JSON_VALID(zswsxz) then replace(JSON_EXTRACT(zswsxz,'$.SCCJMC'),"\"","") else null end as 'SCCJMC', case when JSON_VALID(zswsxz) then replace(JSON_EXTRACT(zswsxz,'$.SCCJ'),"\"","") else null end as 'SCCJ', case when JSON_VALID(zswsxz) then replace(JSON_EXTRACT(zswsxz,'$.CCBH'),"\"","") else null end as 'CCBH', case when JSON_VALID(zswsxz) then replace(JSON_EXTRACT(zswsxz,'$.CCRQ'),"\"","") else null end as 'CCRQ' FROM ( select replace(zswsxz,"'","\"") zswsxz,zswid from dws_grid_wzjscs where eartx ='箱式变电站' and name1 like '%城西%' ) a |