select ascii(substr(a.name,-1,1)) ,a.name from tmp_ziduan a; --0 select ascii(substr(a.name,-2,2)) ,a.name from tmp_ziduan a; --0 select ascii(substr(a.name,-3,2)) ,a.name from tmp_ziduan a; --61138 --51370 无法现身,我怀疑多了字符串的结束字符$
试试trim之后再连接 trim (both from a.name)
trim (both from a.name)
where instr(name,chr(0))>0
[quote=引用 3 楼 u011704394 的回复:] select ascii(substr(a.name,-1,1)) ,a.name from tmp_ziduan a; --0 select ascii(substr(a.name,-2,2)) ,a.name from tmp_ziduan a; --0 select ascii(substr(a.name,-3,2)) ,a.name from tmp_ziduan a; --61138 --51370 无法现身,我怀疑多了字符串的结束字符$
17,377
社区成员
95,128
社区内容
加载中
试试用AI创作助手写篇文章吧