Migrating data from a Firebird database to SQL Server. There is a BLOB Binary field which has values around 20,000 bytes which was measured using OCTET_LENGTH function.
Which SQL Server data type will house more than 8000 bytes?
Migrating data from a Firebird database to SQL Server. There is a BLOB Binary field which has values around 20,000 bytes which was measured using OCTET_LENGTH function.
Which SQL Server data type will house more than 8000 bytes?
Copyright © 2021 Jogjafile Inc.
The closest equivalent to a Firebird
BLOB SUB_TYPE BINARY
(orBLOB SUB_TYPE 0
orBLOB
without explicit subtype), is aVARBINARY(MAX)
. See binary and varbinary (Transact-SQL):There are some differences in how values of these types are accessed (depending on the API used). In Firebird
BLOB
values are stored off-row and are accessed separately (though some APIs will hide this from you), while - IIRC - in SQL Server,VARBINARY
values are stored on-row and APIs will allow you to access the value directly.