Check If the string contains accented characters in SQL?

by

SQL Fiddle: http://sqlfiddle.com/#!6/9eecb7d/1607

declare @a nvarchar(32) = 'àéêöhello!'
declare @b nvarchar(32) = 'aeeohello!'

select case 
    when (cast(@a as varchar(32)) collate SQL_Latin1_General_Cp1251_CS_AS) = @a 
    then 0 
    else 1 
end HasSpecialChars

select case 
    when (cast(@b as varchar(32)) collate SQL_Latin1_General_Cp1251_CS_AS) = @b 
    then 0 
    else 1 
end HasSpecialChars

(based on solution here: How can I remove accents on a string?)

More Related Contents:

  1. How to create a specific SQL Server stored procedure? [closed]
  2. Creating stored procedure getting Incorrect syntax near the keyword ‘Declare’
  3. Conversion failed when converting date and/or time from character string while inserting datetime
  4. How should I pass a table name into a stored proc?
  5. Difference between left join and right join in SQL Server [duplicate]
  6. Get the last inserted row ID (with SQL statement) [duplicate]
  7. Fastest way to remove non-numeric characters from a VARCHAR in SQL Server
  8. Get the week start date and week end date from week number
  9. Run all SQL files in a directory
  10. SELECT FOR UPDATE with SQL Server
  11. Reference an alias elsewhere in the SELECT list
  12. Selecting first row per group
  13. How do I specify date literal when writing SQL query from SQL Server that is linked to Oracle?
  14. How to find column names for all tables in all databases in SQL Server
  15. SQL Row_Number() function in Where Clause
  16. SQL update trigger only when column is modified
  17. Backup a single table with its data from a database in sql server 2008
  18. The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions
  19. COALESCE Function in TSQL
  20. What is the meaning of SELECT … FOR XML PATH(‘ ‘),1,1)?
  21. SQL Server 2005 – Export table programmatically (run a .sql file to rebuild it)
  22. What’s the correct name for an “association table” (a many-to-many relationship) [closed]
  23. Try_Convert for SQL Server 2008 R2
  24. SQL Server variable scope in a stored procedure
  25. Convert bigint to datetime
  26. SQL Sort Order with Null values last
  27. SQL SERVER DATETIME FORMAT
  28. Can’t create stored procedure with table output parameter
  29. Insert all values of a table into another table in SQL
  30. When to use EXCEPT as opposed to NOT EXISTS in Transact SQL?

Leave a Comment