Data Quality | Big Data, Data Analytics and Data Science

Find Non-ASCII character in SQL Server

July 13, 2017 Umesh M Patil Leave a comment

Here is a simple command to find character.

SELECT
	NOTES
	,patindex('%[' + CHAR(127)+ '-' +CHAR(255)+']%' COLLATE Latin1_General_BIN,NOTES) as [Position]
	,substring(NOTES,patindex('%[' + CHAR(127)+ '-' +CHAR(255)+']%' COLLATE Latin1_General_BIN,NOTES),1) as [InvalidCharacter]
	,ascii(substring(NOTES,patindex('%[' + CHAR(127)+ '-' +CHAR(255)+']%' COLLATE Latin1_General_BIN,NOTES),1)) as [ASCIICode]
FROM
      tablename (NOLOCK)
WHERE
      Notes LIKE '%[' + CHAR(127)+ '-' +CHAR(255)+']%'  COLLATE Latin1_General_100_BIN2

Hope it helps.

Regards,
Umesh

Categories: Data Quality, SQL, T-SQL Tags: #ASCII, #SQL

Introduction and Installation of Data Quality Services for Denali

May 24, 2012 Sandip Shinde 2 comments

Data Quality Services (DQS) enables you to discover, build, and manage knowledge about your data. You can then use that knowledge to perform data cleansing, matching, and profiling

DQS is not installed automatically with Microsoft SQL Server Denali CTP3. You must perform additional following steps to complete your Data Quality Server installation, configure it, and then use it. Read more…