sql-server - 检测表中非 ASCII 的 UNICODE 字符

Question

我有下表:

Select
   name,
   address,
   description
from dbo.users

我想在所有这个表中搜索任何 UNICODE 但不是 ASCII 的字符。这可能吗？

Answer 1

您可以非常简单地找到非 ASCII 字符:

SELECT NAME, ADDRESS, DESCRIPTION
FROM DBO.USERS
WHERE NAME != CAST(NAME AS VARCHAR(4000))
OR ADDRESS != CAST(ADDRESS AS VARCHAR(4000))
OR DESCRIPTION != CAST(DESCRIPTION AS VARCHAR(4000))