Subsequent to releasing our Concordance® load file (.DAT) to Concordance Database (.DCB) CPL last week (original post), we have received a few questions regarding Concordance field naming conventions. Concordance field types and field naming requirements are as follows:
Concordance Field Naming Requirements
Field names have to:
- Be no more than 12 characters long
- Start with a letter
- Continue with letters, numbers or the underscore (“_”) character in the middle
As of this writing, a Concordance database can contain no more than 250 fields.
Concordance Field Types
| Field Type | Capacity | Comments |
|---|---|---|
| Paragraph | 12 million characters | Indexed by default, allows rich text |
| Text | Up to 60 characters | Keyed, but not indexed by default |
| Numeric | Up to 20 digits | Keyed by default |
| Date | 8 bytes | Keyed by default |
Concordance is a registered trademark of LexisNexis. Other products or services may be trademarks or registered trademarks of their respective companies.
