January 24, 2025 at 12:00 am
Comments posted to this topic are about the item Counting Bits
January 24, 2025 at 6:05 am
It's not clear to me what this is: "binary expression that isn't a large object (LOB)"
January 27, 2025 at 6:54 pm
A LOB is a type. Binary and varbinary can store very large objects of many bytes. This function works on numeric types.
January 28, 2025 at 5:56 am
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.
January 28, 2025 at 4:51 pm
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 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply