在sqlite中删除9D（十六进制）字符

要在SQLLite中获取HEX（9D），请使用

cast(X'9D' as text)

UPDATE YOURTABLE SET YOURCOLUMN=REPLACE(YOURCOLUMN,cast(X'9D' as text),'')where YOURCOLUMN like '%'||cast(X'9D' as text)||'%'

要不就

UPDATE YOURTABLE SET YOURCOLUMN=REPLACE(YOURCOLUMN,X'9D','') where YOURCOLUMN like '%'||x'9D'||'%';