[SQL] MS SQL CLR function with own type mapping

Is it possible to create a CLR function for SQL that has its own type mapping? For example, there is a column varchar(10) in a SQL table and I want to map it to byte[10]. Or does the CLR function only have to use the default SQL-CLR type mapping?

I don't want to convert varchar to nvarchar and get it into CLR as a string.

Continue reading...