- Posts: 901
- Thank you received: 213
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
Integer values in multiple numeric question
- lfanfoni
- Topic Author
- Offline
- Platinum Member
Less
More
9 years 2 months ago #116314
by lfanfoni
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
Integer values in multiple numeric question was created 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.
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
Attachments:
The topic has been locked.
- DenisChenu
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13907
- Thank you received: 2546
9 years 2 months ago #116323
by DenisChenu
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.
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.
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
- Topic Author
- Offline
- Platinum Member
Less
More
- Posts: 901
- Thank you received: 213
9 years 2 months ago #116331
by lfanfoni
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
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?
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
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13907
- Thank you received: 2546
9 years 1 month ago #116349
by DenisChenu
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.
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
- Topic Author
- Offline
- Platinum Member
Less
More
- Posts: 901
- Thank you received: 213
9 years 1 month ago #116353
by lfanfoni
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
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.
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
- Topic Author
- Offline
- Platinum Member
Less
More
- Posts: 901
- Thank you received: 213
9 years 1 month ago #116524
by lfanfoni
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
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
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.