Kbase P122087: What is the maximum size of characters that can be stored in a CHAR field?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/6/2007 |
|
Status: Unverified
GOAL:
What is the maximum size of characters that can be stored in a CHAR field?
GOAL:
How many characters can be stored in a CHAR field?
FACT(s) (Environment):
OpenEdge 10.x
FIX:
The maximum size of a record is 32,000 bytes.
A single character field can be at most 32,000 bytes long, but in practice a record will almost always have more than one field.
The total of all the fields, not counting LOB fields, must be less than the record size limit.
Character does not always equal byte. Some character sets use more than one byte per character. This is specially true if you are using unicode character which might be represented by 1, 2, 3 or 4 bytes.
Character Large Object fields (clobs) (starting with version 10) can be up to 1 gigabyte long.