Add the different kinds of collations for supported types to testing

[aaronburtle]

We currently support types that have potentially different kinds of collations, but these different collations are not included in our tests. Add in support for testing these different collation types.

More information about collation support in SQL can be found here https://learn.microsoft.com/en-us/sql/relational-databases/collations/collation-and-unicode-support?view=sql-server-ver16

[seantleonard]

@aaronburtle, can you add some example test cases for this to get a better idea of what the missing test coverage is?