07-31-2023, 09:36 AM
[Since SQL Server 2019 varchar columns support UTF-8 encoding.][1]
Thus, from now on, the difference is size.
In a database system that translates to difference in speed.
Less data = Less IO + Less Memory = More speed in general. Read the article above for the numbers.
Go for **varchar in UTF8 from now on!**
Only if you have **big percentage** of data with characters in ranges 2048 - 16383 and 16384 – 65535 - you will have to measure
[1]:
Thus, from now on, the difference is size.
In a database system that translates to difference in speed.
Less data = Less IO + Less Memory = More speed in general. Read the article above for the numbers.
Go for **varchar in UTF8 from now on!**
Only if you have **big percentage** of data with characters in ranges 2048 - 16383 and 16384 – 65535 - you will have to measure
[1]:
[To see links please register here]