为什么语句在navicat中,内容是中文的就正常显示中文,到了帆软设计器里面中文变成乱码(可有偿)

1、在navicat中显示的样子,中文都正常

6bb8e36f1801f8d30091c9a23f05e25.png

2、在设计器里,中文全部变成乱码

bb62d9a5a9c0a23a4ffcffa546989e3.png

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

FineReport mmc0112 发布于 2022-12-13 15:27 (编辑于 2022-12-13 15:28)
1min目标场景问卷 立即参与
回答问题
悬赏:3 F币 + 添加悬赏
提示:增加悬赏、完善问题、追问等操作,可使您的问题被置顶,并向所有关注者发送通知
共3回答
最佳回答
0
LoverLv4见习互助
发布于2022-12-13 15:41

中文不要replace,在帆软设计器中再replace并隐藏带双引号的列

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

image.png

最佳回答
0
weibwLv7高级互助
发布于2022-12-13 15:30
最佳回答
0
yzm339714Lv6中级互助
发布于2022-12-13 15:30(编辑于 2022-12-13 15:35)

~~

  • 3关注人数
  • 326浏览人数
  • 最后回答于:2022-12-13 15:41
    请选择关闭问题的原因
    确定 取消
    返回顶部