The default length is 1 when n isn't specified in a data definition or variable declaration statement. When n isn't specified with the CAST function, the default length is 30. Data type Use when ...

View an example of an SQL query that retrieves binary data using the RAW and BINARY BASE64 options with the FOR XML clause. The following query returns the product photo stored in a varbinary(max) ...