I'm writing a piece of code that uses pattern matching on unicode characters but I'm running into an odd problem. Some characters work and some don't.
DECLARE @Pattern nvarchar(50) = N'%[^a-z]%' -- Simple pattern SELECT PatIndex(@Pattern, nchar(46797)), nchar(46797) -- Works SELECT PatIndex(@Pattern, nchar(14843)), nchar(14843) -- Doesn't Work
The pattern should be pulling for any character that isn't a-z but for some reason it isn't catching some characters. Does anyone know why some unicode characters would match and others wouldn't?