如何在SQL Server 表的NTEXT字段中找到Unicode /非ASCII字符？

SELECT * FROM your_table
WHERE CHARINDEX(N'你要查找的字符', your_ntext_column) > 0

SELECT * FROM your_table
WHERE your_ntext_column LIKE N'%你要查找的模式%'

SELECT * FROM your_table
WHERE PATINDEX(N'你要查找的模式', your_ntext_column) > 0

SELECT SUBSTRING(your_ntext_column, CHARINDEX(N'你要查找的字符', your_ntext_column), LEN(your_ntext_column))
FROM your_table
WHERE CHARINDEX(N'你要查找的字符', your_ntext_column) > 0

DECLARE @xml XML
SET @xml = CAST(your_ntext_column AS XML)

SELECT @xml.value(N'//text()[contains(., "你要查找的字符")]', 'nvarchar(max)')
FROM your_table
WHERE @xml.exist(N'//text()[contains(., "你要查找的字符")]') = 1