I first came to learn about the complexity of character sets by finding out that SQL Server's default characterset is 2 bytes per character. I eventually came across Scott's video. UTF-8 encoding is only as new as SQL Server 2019.

https://sqlquantumleap.com/2018/09/28/native-utf-8-support-i...