I am developping a database with different codes that contain integrity checks. I have developed these checks in TSQL and implemented them as scalar valued functions that I use as check constraints. Since it is pure numerical calculation without data access, this seemed to me to be a good candidate to develop in vb.net. It seems however that in CLR the char() datatype doesn't exist. So I am left with the choice of converting the columns to unicode, doubling the number of bytes stored; or converting at runtime dbo.fn_check(N column) and again taking a performance hit?
Isn't there another way round?
Thanks,
Jan