Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

Integer values in multiple numeric question

  • lfanfoni
  • lfanfoni's Avatar Topic Author
  • Offline
  • Platinum Member
  • Platinum Member
More
9 years 2 months ago #116314 by lfanfoni
When I use a multiple numeric question (ls 2.05) and integer numbers are inserted, they are stored and presented with the decimal format (see the screenshot).

This problem doesn't happen in 1.92, I think the cause is the different field type used for numeric questions (from "double" to "numeric(30.10)), in MySql, obviously.

Se mi vuoi contattare, non mandare messaggi privati qui, bensì scrivi a lfanfoni at gmail.com
Per le livestream in italiano vai su: www.youtube.com/playlist?list=PLOSjjxAG9...SiiCsSz_JxIH7xJwLdPd
Le soluzioni LimeSurvey per l'Italia si trovano su: github.com/lfanfoni
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
9 years 2 months ago #116323 by DenisChenu
Replied by DenisChenu on topic Integer values in multiple numeric question
Did you have a look at our bug report ?

This "bug" is already fixed for "public" part.

Decimal(30,10) is better for BIG number.

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The topic has been locked.
  • lfanfoni
  • lfanfoni's Avatar Topic Author
  • Offline
  • Platinum Member
  • Platinum Member
More
9 years 2 months ago #116331 by lfanfoni
Replied by lfanfoni on topic Integer values in multiple numeric question
I've solved returning to double type in result table, I have an important survey to start up.
But I've the suspect that is a problem of format coding in MySql database and compatibility in ls, cause I've problem also with date and string (characters as à, è, etc, etc). But these errors are quite random.
Can someone suggest to me a "stable" format code for MySql database of 2.05 version of ls?

Se mi vuoi contattare, non mandare messaggi privati qui, bensì scrivi a lfanfoni at gmail.com
Per le livestream in italiano vai su: www.youtube.com/playlist?list=PLOSjjxAG9...SiiCsSz_JxIH7xJwLdPd
Le soluzioni LimeSurvey per l'Italia si trovano su: github.com/lfanfoni
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
9 years 1 month ago #116349 by DenisChenu
Replied by DenisChenu on topic Integer values in multiple numeric question
I dpn't understand : "stable" format code ????

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The topic has been locked.
  • lfanfoni
  • lfanfoni's Avatar Topic Author
  • Offline
  • Platinum Member
  • Platinum Member
More
9 years 1 month ago #116353 by lfanfoni
Replied by lfanfoni on topic Integer values in multiple numeric question
Characters set, sorry. I've just checked that MySql database is defined as utf8_unicode_ci, and also web server where ls is installed produces pages in the "unicode" character set.
Maybe I should update my build 140821. But now I cannot...too much respondents for the next weeks.

Se mi vuoi contattare, non mandare messaggi privati qui, bensì scrivi a lfanfoni at gmail.com
Per le livestream in italiano vai su: www.youtube.com/playlist?list=PLOSjjxAG9...SiiCsSz_JxIH7xJwLdPd
Le soluzioni LimeSurvey per l'Italia si trovano su: github.com/lfanfoni
The topic has been locked.
  • lfanfoni
  • lfanfoni's Avatar Topic Author
  • Offline
  • Platinum Member
  • Platinum Member
More
9 years 1 month ago #116524 by lfanfoni
Replied by lfanfoni on topic Integer values in multiple numeric question
The problem persists with the last build (141229), and there is another recent post about this problem:
www.limesurvey.org/en/forum/italian-foru...poste-in-formato-pdf

Se mi vuoi contattare, non mandare messaggi privati qui, bensì scrivi a lfanfoni at gmail.com
Per le livestream in italiano vai su: www.youtube.com/playlist?list=PLOSjjxAG9...SiiCsSz_JxIH7xJwLdPd
Le soluzioni LimeSurvey per l'Italia si trovano su: github.com/lfanfoni
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose