QAID # 18265 Published
Question / Problem:
How are long values stored internally for Index and Batch Fields?
Answer / Solution:
When configuring Batch and Index Fields, datatypes of CHAR/VARCHAR are limited to 254 characters for default values. However, when additional text is required/added during validation, the excess characters are stored in a a separate database table.
The following assumes Batches are stored in SQL Server.
- The default value is stored in the
IndexFieldtable and has a maximum length of 254 characters.
BatchField.Valuestores up to 254 characters and is populated after Validation from the
IndexFieldtable if accepting the default value, or a different value if changed (max. 254 chars).
- If the Index Field value exceeds 254 characters, the excess data is stored in the
Keywords: Index field limitations, Maximum field length