Add the different kinds of collations for supported types to testing

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