<div>
how is this column defined?<br />
if it is defined as varchar / char then it can not contain unicode characters<br />
if it is defined as nvarchar / nchar then it can<br />
they question is, which characters are you after?<br />
if you only want to find russian characters, i think your best options is to use some regular expression, for example<br />
<br />
select *<br />
from table<br />
where suspected_column like '%[a-z]%'<br />
<br />
but replace a with the first character in russian and z with the last one
</div>


<div>
start from data types :<br />
<br />
In SQL Server, data types that support Unicode data are: nchar nvarchar nvarchar(max)  new in SQL Server 2005 ntext <br />
--<br />
then check: column COLLATION from [INFORMATION_SCHEMA].[COLU<wbr />MNS]<br />
--- <br />
<br />
use yourDB<br />
<br />
SELECT [TABLE_CATALOG], <br />
[TABLE_SCHEMA], <br />
[TABLE_NAME],<br />
[COLUMN_NAME], <br />
[COLLATION_NAME],<br />
[DATA_TYPE]<br />
<br />
FROM [INFORMATION_SCHEMA].[COLU<wbr />MNS]<br />
&nbsp;<br />

</div>


<div>
Sorry. I forgot to mention that the data type is nvarchar(50). Not only Russian unicode characters, also Romanian and so on.
</div>


<div>
ok<br />
so just find out what are the unicode enconding of 'a' and 'z' and then perform<br />
<br />
select *<br />
from table<br />
where suspected_column like '%[^0-9'a-z]%'<br />
<br />
this will return any string that contain non-english and non-digit characters<br />

</div>


<div>
also check:<br />
UNICODE function:<br />
<a href="http://msdn.microsoft.com/en-us/library/aa260660(SQL.80).aspx" rel="ugc">http://msdn.microsoft.com/<wbr />en-us/libr<wbr />ary/aa2606<wbr />60(SQL.80)<wbr />.aspx</a> <br />
--<br />
and as idea:<br />
&nbsp;Remove Special Character from XML string using SQL Server<br />
<a href="http://helpindotnet.wordpress.com/2008/06/02/remove-special-character-from-xml-string-using-sql-server/" rel="ugc">http://helpindotnet.wordpress.com/2008/06/02/remove-special-character-from-xml-string-using-sql-server/</a>&nbsp;<br />

</div>


<div>
do you have <br />
check example from<br />
<a href="http://saloon.javaranch.com/cgi-bin/ubb/ultimatebb.cgi?ubb=get_topic&f=3&t=012414" rel="ugc">http://saloon.javaranch.co<wbr />m/cgi-bin/<wbr />ubb/ultima<wbr />tebb.cgi?u<wbr />bb=get_top<wbr />ic&amp;f=3&amp;t=0<wbr />12414</a> <br />
&nbsp;<br />
<a href="https://www.experts-exchange.com/questions/23035517/How-do-I-replace-the-non-printable-unicode-characters-in-my-news-title.html" rel="ugc">http://www.experts-exchang<wbr />e.com/Prog<wbr />ramming/La<wbr />nguages/C_<wbr />Sharp/Q_23<wbr />035517.htm<wbr />l</a> <br />
&nbsp;<br />
<a href="http://www.codeproject.com/KB/reporting-services/UnicodeInSQLServer.aspx" rel="ugc">http://www.codeproject.com/KB/reporting-services/UnicodeInSQLServer.aspx</a>&nbsp;<br />

</div>


<div>
Thank you to all for your help. Problem solved.<br />
Raluca
</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have a table in a Sql Server 2005 database with the collation type SQL_Latin1_General_CP1_CI_<wbr />AS<br />
Can you tell me how can I run a select query on 1 field to identify the entries with non ASCII, but Unicode characters (eg Russian characters)?<br />
<br />
Raluca
</div>
</div>


Hi,

I have a table in a Sql Server 2005 database with the collation type SQL_Latin1_General_CP1_CI_AS
Can you tell me how can I run a select query on 1 field to identify the entries with non ASCII, but Unicode characters (eg Russian characters)?

Raluca

How to find records containing Unicode characters?

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.