Kbase P79027: What is the maximum characters that can be stored in a CHAR field?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
02/08/2004 |
|
Status: Unverified
GOAL:
What is the maximum characters that can be stored in a CHAR field?
FIX:
1. The maximum size of a record is roughly 32,000 bytes.
2. A single /char/ field can be at most 32,000 bytes long, but in practice a record will almost always have more than one field.
3. The total of all the fields, not counting lob fields, must be less than the record size limit.
4. Character does not always equal byte. Some character sets use more than one byte per character.
5. Character large object fields (clobs) (starting with version 10) can be up to 1 gigabyte long.