SQL Server stores unicode data using the UCS2 encoding. UTF8 is not supported in SQL Server.

That said, there's nothing stopping you to store unicode data in SQL Server, even if the encodings is not UTF8. Can you please expand your question with some context?