Cannot import preferred language field using label
Overview
Trying to import contacts including the preferred language column which contains Option Labels e.g. English (Australia) doesn't work, causes a DB error as it tries to insert in a too long a string.
Reproduction steps
- Create a CSV to import contacts including the preferred language field with at least one entry containing the language option value.
- Perform import process.
- Got an error "Fatal error: DB unknown error". Due to field content being too long
Current behaviour
Import fails
Expected behaviour
Import succeeds
Environment information
- CiviCRM: Master
- PHP: 7.3
- CMS: Drupal 7
To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information