Check out the LimeSurvey source code on GitHub!

Comment field only save first five characters

More
5 years 8 months ago #62323 by gen72
Hello, I have a complete survey done with this amazing software.
My problem is when the user fills with a comment a "Multiple choice with comments" question, only the first five characters are saved into database.
(The user write "Master" and on database only "Maste" is stored)

How can I solve it?

Thanks
Attachments:

Please Log in to join the conversation.

More
5 years 8 months ago #62402 by gen72
I have solved this problem modifying the field on database from varchar(5) to varchar(80).
Somebody knows if this change on database can cause any problems in the future?

Thanks

Please Log in to join the conversation.

More
5 years 8 months ago #62414 by tpartner
This sounds like a bug. Are you using the latest stable version?

Cheers,
Tony Partner

Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.

Please Log in to join the conversation.

More
5 years 7 months ago #62819 by Yurij

Please Log in to join the conversation.

More
5 years 7 months ago #63385 by mmoloi
Changing the field type from varchar(5) to varchar(80) has no implications as it just saying increase the number of characters I can store in that field - And yes an answer to your question was the issue of varchar(5).

Please Log in to join the conversation.

More
4 years 10 months ago #78267 by hrshdhgd
hey gen72,

I need to change varchar(5) to varchar(255) but I don't know where to change the settings. Could you guide me regarding this issue?

Thanks in advance,
H.

Please Log in to join the conversation.

More
4 years 10 months ago #78272 by holch
This problem should be long solved. What is the problem you need to solve?

I'm not a LimeSurvey GmbH member. I answer at the LimeSurvey forum in my spare time. No support via private message.
Some helpful links: Manual (EN) | Question Types | Workarounds

Please Log in to join the conversation.

More
4 years 10 months ago - 4 years 10 months ago #78303 by hrshdhgd
I have a problem where in when I import an external database into LimeSurvey (the database is modified to comply with the import requirements), I get an error message for all the entries which have long comments (in the 'others' option of my survey) saying that the data is too long for a varchar(5) data type declared column. I want to change the varchar(5) data type of those columns to varchar(255). All other entries without comments have been imported successfully.

The exact error message "[ERROR: value too long for type character varying(5)]"

Thanks in advance,
H.
Last Edit: 4 years 10 months ago by hrshdhgd. Reason: error message inclusion

Please Log in to join the conversation.

Imprint                   Privacy policy         General Terms & Conditions         Revocation information and revocation form