Counting Bits
-
Comments posted to this topic are about the item Counting Bits
-
It's not clear to me what this is: "binary expression that isn't a large object (LOB)"
-
A LOB is a type. Binary and varbinary can store very large objects of many bytes. This function works on numeric types.
-
I know what a LOB is.
Are CHAR(10) or DATE of type LOB?
(They are also defined by a fixed number of bits!)
The vague definition is really inappropriate for a function definition document.
-
Char(10) and date aren't binary types. They throw errors. I agree that "binary expression that isn't a large object" isn't a great definition. On this page (https://learn.microsoft.com/en-us/sql/connect/ado-net/sql/modify-large-value-max-data?view=sql-server-ver16) it says LOB are those that exceed 8kb (1 page). That's what I would have assumed, and I know that this text is repeated in a few places.
This seems to bear out in testing. First 2 work, 3rd fails.
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply