Kbase P184633: When LOBs are stored in a database is it based on the actual size of the LOB or the field definition
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/23/2011 |
|
Status: Unverified
GOAL:
When we store lobs, do we do so based on the defined LOB-SIZE that is allocated or is it more like a character field where only the actual size of the data is stored?
GOAL:
When storing a LOB field is it only the size of the LOB that gets stored or is it based on LOB-SIZE defined for the field in the Data Dictionary?
GOAL:
When LOBs are stored in a database is it based on the actual size of the LOB or the field definition LOB-SIZE?
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.x
FIX:
The data that is stored in a LOB field is based on the actual size of the LOB and not on the LOB-SIZE defined in the Data Dictionary in the Field Editor.
The purpose of the LOB-SIZE in the Field Editor is to identify a maximum size for the field. The reason for this, is to ensure that something larger than the maximum size is not stored within the field that the application may not be prepared to handle.