回复 sunyangnj 但是hit 有点低
ASCII >=129 的全是隐含不显示的字符再加上ASC127 之内的 ,没几个
self_tuning_mem 这个参数为ON?
如果不干掉你就直接这么办:SELECT CASE WHEN A IS NULL OR A = '' OR LENGTH(RTRIM(A)) = 0 THEN '1' when ASCII(A)=182 then chr(182)ELSE A END AS A FROM B
select chr(182) from sysibm.sysdummy1
只能用ASCII 将这个诡异的字符干掉了
SELECT CASE WHEN A IS NULL OR A = '' OR LENGTH(RTRIM(A)) = 0 OR ASCII(A)=182 THEN '1' ELSE A END AS A FROM 。。。。。。。。这个字符好像挺诡异
select ASCII(biz03) from BIZDATA;
回复 wp28556259 牛总是哪位? 那位超级专家?
关于TWT使用指南社区专家合作厂商入驻社区企业招聘投诉建议版权与免责声明联系我们 © 2024 talkwithtrend — talk with trend,talk with technologist京ICP备09031017号-30