You're welcome. To be clear, using a binary collation won't help if you forget to indicate that the data is NVARCHAR, either by declaring the variable to be NVARCHAR or prefixing the string literal with an upper-case "N". For example (and this time I used Code Point U+2007 which is "Figure Space", another type of space character):
SELECT CHARINDEX(' ', 'aa?bb cc');
-- 3
SELECT CHARINDEX(' ' COLLATE Latin1_General_100_BIN2, 'aa?bb cc');
-- 3
SELECT CHARINDEX(N' ', N'aa?bb cc');
-- 6
Also, you might find it helpful to read:
How Many Bytes Per Character in SQL Server: a Completely Complete Guide