- Subscribe to RSS
- What is BLOB data type in MySQL?
- Using advanced data types
- dotConnect for Oracle
- Binary Large Object (Blob) Data (SQL Server)
What is BLOB data type in MySQL?
Using advanced data types
Azure Blob storage is Microsoft's object storage solution for the cloud. Blob storage is optimized for storing massive amounts of unstructured data. Unstructured data is data that doesn't adhere to a particular data model or definition, such as text or binary data. Client libraries are available for different languages, including:. Azure Data Lake Storage Gen2 offers a hierarchical file system as well as the advantages of Blob storage, including:. A storage account provides a unique namespace in Azure for your data. Every object that you store in Azure Storage has an address that includes your unique account name. The combination of the account name and the Azure Storage blob endpoint forms the base address for the objects in your storage account. For example, if your storage account is named mystorageaccountthen the default endpoint for Blob storage is:. To create a storage account, see Create a storage account. To learn more about storage accounts, see Azure storage account overview. A container organizes a set of blobs, similar to a directory in a file system. A storage account can include an unlimited number of containers, and a container can store an unlimited number of blobs. The container name must be lowercase. For more information about naming containers, see Naming and Referencing Containers, Blobs, and Metadata. You may also leave feedback directly on GitHub. Skip to main content. Exit focus mode. Learn at your own pace. See training modules. Dismiss alert. About Blob storage Blob storage is designed for: Serving images or documents directly to a browser. Storing files for distributed access. Streaming video and audio. Writing to log files. Storing data for backup and restore, disaster recovery, and archiving. Storing data for analysis by an on-premises or Azure-hosted service. NET Java Node. Blob storage resources Blob storage offers three types of resources: The storage account A container in the storage account A blob in a container The following diagram shows the relationship between these resources. Storage accounts A storage account provides a unique namespace in Azure for your data. Containers A container organizes a set of blobs, similar to a directory in a file system. Note The container name must be lowercase. Is this page helpful? Yes No. Any additional feedback?
dotConnect for Oracle
A BLOB is a binary large object that can hold a variable amount of data. These differ only in the maximum length of the values they can hold. These correspond to the four BLOB types and have the same maximum lengths and storage requirements. BLOB values are treated as binary strings byte strings. They have the binary character set and collation, and comparison and sorting are based on the numeric values of the bytes in column values. TEXT values are treated as nonbinary strings character strings. They have a character set other than binaryand values are sorted and compared based on the collation of the character set. For truncation of nonspace characters, you can cause an error to occur rather than a warning and suppress insertion of the value by using strict SQL mode. Truncation of excess trailing spaces from values to be inserted into TEXT columns always generates a warning, regardless of the SQL mode. If a TEXT column is indexed, index entry comparisons are space-padded at the end. This means that, if the index requires unique values, duplicate-key errors will occur for values that differ only in the number of trailing spaces. This is not true for BLOB columns. This is a compatibility feature. The maximum size of a BLOB or TEXT object is determined by its type, but the largest value you actually can transmit between the client and server is determined by the amount of available memory and the size of the communications buffers. This is in contrast to all other data types, for which storage is allocated once per column when the table is opened. You may find MySQL's string handling functions useful for working with such data. For security and other reasons, it is usually preferable to do so using application code rather than giving application users the FILE privilege. Numeric Type Attributes. Out-of-Range and Overflow Handling. Date and Time Data Type Syntax. Fractional Seconds in Time Values. Conversion Between Date and Time Types. The Geometry Class Hierarchy. GeometryCollection Class. MultiLineString Class. Supported Spatial Data Formats. Geometry Well-Formedness and Validity. Creating Spatial Columns. Populating Spatial Columns. Optimizing Spatial Analysis. Creating Spatial Indexes. Data Type Storage Requirements. Choosing the Right Type for a Column. Errors, Error Codes, and Common Problems. MySQL 5.