Modern database systems in addition to supporting a number of standard common data types, most also support a kind of data called blob type.BLOBs are all called big large object bytes, a sophomore, and this type of data is typically used to store
1. How to Deal with clob in MySQL and Oracle databases. BLOB data type (1) cannot be connected to clob in the database. The Blob type is as follows:
MySQL: clob corresponds to text and blob
In DB2/Oracle: clob corresponds to clob and blob(2)
In Oracle, fields of the lob (large object, large object) type are increasingly used. This type of field has a large capacity (up to 4 GB of data), and a table can have multiple fields of this type, which is flexible, applicable to business areas
oracle| Data Oracle's BLOB field is special, he is much better than a long field, and can be used to save binary data, such as pictures.
It is very different to write a BLOB field and write to another type of field, because the BLOB itself has a
This article explains the BLOB data types that SQLServer uses to access and store data, parses SQLServerBLOB data storage, access methods, and how to reduce the total cost of each byte stored in your SQLServerBLOB. BLOB data is a field with a large
Requirement: serialize the object and save it to the database. The database design uses the BLOB data type, the Oracle database, and Hibernate to save the Blob big data. ibatis queries the Blob big data.
Some codes are presented as follows:
1.
field type select text type or blog difference see: The following article focuses on the differences between MySQL text and the Blob field type, as well as an introduction to the actual application of MySQL text and blob field types, if you are
Address: http://fengwen.iteye.com/blog/580323
Problem: a xx Settlement System requires transaction statistics from another system, which stores and exports images for viewing.
The Slice directly exists in the database as blob. I thought it was a
Why does the GROUP_CONCAT function in MySQL return the BLOB large object type? (Why GROUP_CONCAT returns BLOB ?), Group_concatblob
Why does the GROUP_CONCAT function in MySQL return the BLOB large object type? (Why GROUP_CONCAT returns BLOB
LOB types are divided into BLOBs and CLOB two: BLOBs-binary large pair images (Binary Large Object), which are used to store text-throttling data (such as programs, images, audio, video, and so on). CLOB, a character-type large pair (Character Large
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.