Kurono,
Revisa estos links:
1-
http://www.dbforums.com/microsoft-sq...er-2000-a.html
2-
http://www.databasejournal.com/featu...ver-Part-2.htm
El tipo de campo blob en SQL Server 2000 es Image.
Cita:
Tomado del libro : Microsoft SQL Server 2000 Bible de Paul Nielsen, Editorial Wiley.
"SQL Server can store any binary object up to 2GB, which definitely qualifies as a binary large object (blob) in an image column"
|
Cita:
Tomado del link 2:
"SQL BOL (Books On Line) gives a good example of the three binary types:
-Use Binary when the sizes of the column data entries are consistent (and less than 8,000 bytes).
-Use varBinary when the sizes of the column data entries vary considerably (and are less than 8,000 bytes).
-Use varBinary(max) when the column data entries exceed 8,000 bytes.
-For SQL 2000, use the Image data type. However, be aware that Microsoft has stated the Image data type is for backwards compatibility only, and may be discontinued on a future version."
|
Te anexo una tabla del mencionado libro que define el campo blob Image.
Espero sea útil
Nelson.