如何在 SQL Server 2005 表的 NTEXT 字段中找到 Unicode/非 ASCII 字符? [英] How can I find Unicode/non-ASCII characters in an NTEXT field in a SQL Server 2005 table?

问题描述

我有一张有几千行的表.描述和摘要字段是 NTEXT，有时其中包含非 ASCII 字符.如何找到所有包含非 ASCII 字符的行?

I have a table with a couple thousand rows. The description and summary fields are NTEXT, and sometimes have non-ASCII chars in them. How can I locate all of the rows with non ASCII characters?

推荐答案

我有时会使用这个cast"语句来查找奇怪"的字符

I have sometimes been using this "cast" statement to find "strange" chars

select 
    *
from 
    <Table>
where 
    <Field> != cast(<Field> as varchar(1000))

这篇关于如何在 SQL Server 2005 表的 NTEXT 字段中找到 Unicode/非 ASCII 字符?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！