SELECT COL_NAME
FROM table_name
WHERE ASCIISTR(COL_NAME) LIKE '%\FFFD%'
OR COL_NAME IS NOT NULL AND ASCIISTR(COL_NAME) IS NULL
OR ASCII(SUBSTR(ASCIISTR(COL_NAME)
Oracle查找乱码的数据
最新推荐文章于 2022-08-23 21:12:52 发布
SELECT COL_NAME
FROM table_name
WHERE ASCIISTR(COL_NAME) LIKE '%\FFFD%'
OR COL_NAME IS NOT NULL AND ASCIISTR(COL_NAME) IS NULL
OR ASCII(SUBSTR(ASCIISTR(COL_NAME)