hello,
this is a followup question to http://stackoverflow.com/questions/3661641/len-of-varbinary
len(0x0a0b0c0d) returns 4 because len counts bytes. does this behaviour depend on the current server collation? if i chose utf-16 for example, would it return 2? in other words, does len treat its argument as string or does it distinguish parameter types and just counts bytes for binary?
i am using mssql 2005
thanks konstantin