Fun and profit with UTF-8
When SQL Server 2019 was announced, it brought with it UTF-8 support. Also available in Azure SQL Database, UTF-8 is exciting if you have a legacy database and application that needs to support Unicode strings…
The easy way to handle UTF-8 in a .NET application when dealing with SQL Server 2019
A short post this week. On a mailing list recently, someone noticed that a .NET application writing to SQL Server did not have the expected behaviour with UTF-8 collation and data types. To refresh our…
Data Types and Collation
Last week we started with a very simple definition of a database: a discrete set of information, with a specific structure and order to it. We briefly looked at normalization, which is a way to…