Tag names with non-ASCII characters (diacritics, etc.)

1

Please login or register to vote for this query.

(click on this box to dismiss)

Portuguese Language

Q&A for linguists, teachers and learners wanting to discuss the finer points of the Portuguese language

SELECT
  -- t.TagName AS [TagName], -- fails with ASCII: http://meta.stackexchange.com/questions/226703/auto-linkification-of-tags-tagname-fails-when-the-tag-name-contains-nonstandard
  t.TagName AS [Tag],
  t.Count AS [Count],
  (
    SELECT s.SourceTagName + ' '
    FROM TagSynonyms s
    WHERE s.ApprovedByUserId IS NOT NULL AND s.TargetTagName = t.TagName
    FOR XML PATH('')
  ) AS [Synonyms]
FROM Tags t
WHERE t.TagName LIKE '%[^-#+.0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz]%'
ORDER BY t.TagName ASC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results