且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

什么是 DBMS 上下文中的 BLOB

更新时间:2023-11-14 23:52:40

BLOB :

BLOB (Binary Large Object) 是数据库系统中的一种大对象数据类型.BLOB 可以存储大量数据、文档类型甚至音频或视频文件等媒体文件.BLOB 字段仅在字段中的内容被利用时才分配空间.BLOB 以千兆字节为单位分配空间.

BLOB (Binary Large Object) is a large object data type in the database system. BLOB could store a large chunk of data, document types and even media files like audio or video files. BLOB fields allocate space only whenever the content in the field is utilized. BLOB allocates spaces in Giga Bytes.

BLOB 的使用:

您可以将二进制大对象 (BLOB) 作为二进制或字符数据写入数据库,具体取决于数据源中的字段类型.要将 BLOB 值写入您的数据库,请发出适当的 INSERT 或 UPDATE 语句并将 BLOB 值作为输入参数传递.如果您的 BLOB 存储为文本,例如 SQL Server 文本字段,您可以将 BLOB 作为字符串参数传递.如果 BLOB 以二进制格式存储,例如 SQL Server 图像字段,则可以将字节类型的数组作为二进制参数传递.

You can write a binary large object (BLOB) to a database as either binary or character data, depending on the type of field at your data source. To write a BLOB value to your database, issue the appropriate INSERT or UPDATE statement and pass the BLOB value as an input parameter. If your BLOB is stored as text, such as a SQL Server text field, you can pass the BLOB as a string parameter. If the BLOB is stored in binary format, such as a SQL Server image field, you can pass an array of type byte as a binary parameter.

一个有用的链接:将文档作为 BLOB 存储在数据库中 -有什么缺点吗?