Record Producer truncates variable responses

[nickt]

We have a record producer which is truncating responses to questions at 40 characters.

The question responses are select box questions, which may have longer than 40 character choices for the response.

Field character limits on text fields, responses, and the target table have all been set to 250 characters, but this is still happening.

Can anyone explain why, and what I can do to resolve the issue?

[DanielCordick]

the question may be set at 250

but if the dictionary record for that question type is still 40 it will truncate.. just a thought 

[ar7009297]

• Choice Label → The human-readable text shown to the user (can be long)

• Choice Value → The value stored/submitted in the variable (limited to 40 by default)

If you don't manually extend the value field length, it silently truncates anything longer than 40.

Extend the "Value" field in the question_choice table from 40 → 250 chars.
That will stop truncation.

[ar7009297]

Choice Label - The human-readable text shown to the user (can be long)

Choice Value - The value stored/submitted in the variable (limited to 40 by default)

If you don't manually extend the value field length, it silently truncates anything longer than 40.

Extend the "Value" field in the question_choice table from 40 - 250 chars.

That will stop truncation.

[Ankur Bawiskar]

@nickt 

very difficult to understand without screenshot

share some screenshots and which variable type you are referring?

If my response helped please mark it correct and close the thread so that it benefits future readers.