A blob is a type of MySQL data, called a binary large object. As its name it is used to store a large number of string data like MySQL binary and varbinary types.
MySQL BLOB classification
MySQL blob type maximum storage length (bytes)
Tinyblob (1
BLOB is a MySQL data type called a binary large object. Just like its name, it is used to store class & amp; 20284; MYSQL binary and VARBINARY type, a large amount of string data. MySQLBLOB classification MySQLBLOB type maximum storage length (bytes)
Insert and display images in Oracle (BLOB type)Blob type for storing images in oracle
First, create a database:
-- Connect to the AdministratorConn sys/tbsoft as sysdba;
-- Authorize scott user
Grant create any directory to scott;
-- Return to scott
BLOB isMySQLThe data type is called a binary large object. Just like its name, it is used to store a large amount of string data similar to MYSQL binary and VARBINARY.
MySQL BLOB Classification
Maximum storage length (bytes) of MySQL BLOB
PHP uses BLOB to access picture information instances
BLOB Introduction
MySQL blob type
Create a database
PHP file into binary code
HTML code
Read binary picture
PHP Full Code
HTML code
PHP uses BLOB to access picture information
A blob is a MySQL data type called a binary large object. As its name it is used to store a large number of string data similar to the MySQL binary and varbinary type.
MySQL BLOB classification
MySQL blob type maximum storage length (bytes)Tinyblob (
Clob mainly saves huge amounts of text, while BLOBs are dedicated to storing binary data: including, pictures, music, movies. such asIn MySQL, blob types use the Longblob declaration to store up to 4G of content.Create a table:CREATE TABLE Userblob (
1. mysql in the Blob field typeThe type of BLOB farm is used to store binary data.MySQL in. Blob It is a series of types. Contains: Tinyblob, Blob, Mediumblob, Longblob. vary in size.MySQL four types of blobsTinyblob: Maximum 255 bytesBlob: 65K
I have carefully read the ibatis document over the past few days and found that after 2.2, the ibatis change is quite big. The support for custom types is also good, so that the processing of blob and clob data is much simpler.However, Spring
After leaving the network for more than a week, I finally returned to the group. Some netizens raised the following questions:CYQ. Data framework test: mysql database test (problems may occur when storing blob-type Data). Test the mysql database: If
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.