• SQL Kiwi (12/3/2012)


    Jaroslav Pfauser (12/3/2012)


    (0 row(s) affected)

    SQL2008 (64-bit) SP2

    It seems you wrote a test script that did not cover the full range of possibilities. Include CHAR(198) and CHAR(230) in your test.

    (2 row(s) affected)

    Doesn't the test sql provided in answer already do that?

    On my server it returns 0 rows, so it appears like some other things affect this. Maybe default collation. Probably.