Comment by SigmundA

We are talking nvarchar here, yes UTF-8 solves this issue completely and MSSQL supports it now days with varchar.