views:

39

answers:

0
+1  Q: 

len of varbinary 2

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