Polish special characters in open answers

More
3 years 5 months ago #108999 by PerOlander
PerOlander created the topic: Polish special characters in open answers
Hi,

We are running a lot of surveys in Polish, and whenever there is an open text, or "other" with a sub-string, limesurvey doesnt seem to handle the Polish special characters correct.

they are displayed as "?", both when exporting to excel, and when previewing the file directly in limesurvey.

is there any sort of setting where I can change this?

Best Regards,
Per Olander

Please Log in to join the conversation.

More
3 years 5 months ago #109027 by DenisChenu
DenisChenu replied the topic: Polish special characters in open answers
Hi,

LS are utf8 ready, what is your LimeSurvey version ?

Did yountry to open the file with LibreOffice.

Denis

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand (or search sondages pro).
An error happen ? Before make a new topic : remind the Debug mode .

Please Log in to join the conversation.

More
3 years 5 months ago #109031 by PerOlander
PerOlander replied the topic: Polish special characters in open answers
Hi Denis,

thanks for you answer!

we run Version 2.00+ Build 131206

I have not tried LibreOffice yet, I will do - but a solution for Excel is appreciated, since it is part of a bigger VBA setup.
however, the characters are also not showing correctly when previewed in LS, so it doesnt seem to be an Excel issue? see picture:
www.dropbox.com/s/2iw63ohb1lv0206/LS_polish_characters.png

Please Log in to join the conversation.

More
3 years 5 months ago #109035 by DenisChenu
DenisChenu replied the topic: Polish special characters in open answers
Can you provide a little lsa file ?

I think it's clean on LS 2.00 too.

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand (or search sondages pro).
An error happen ? Before make a new topic : remind the Debug mode .

Please Log in to join the conversation.

More
3 years 5 months ago #109037 by PerOlander
PerOlander replied the topic: Polish special characters in open answers
I am off for a meating now - within the next 3 hours, I will make a Demo-survey with some dummy data that I can give you an export file for - I will export both the csv and excel version.

thanks again!

Please Log in to join the conversation.

More
3 years 5 months ago #109039 by DenisChenu
DenisChenu replied the topic: Polish special characters in open answers
No,

Export the survey archive (lsa file), answers are inside.

Denis

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand (or search sondages pro).
An error happen ? Before make a new topic : remind the Debug mode .

Please Log in to join the conversation.

More
3 years 5 months ago #109048 by PerOlander
PerOlander replied the topic: Polish special characters in open answers
I have taken this string, and entered as an answer in the survey:
AaĄąBbCcĆćDdEeĘęFfGgHhIiJjKkLlŁłMmNnŃńOoÓóPpRrSsŚśTtUuWwYyZzŹźŻż
letters are taken from:
en.wikipedia.org/wiki/Polish_alphabet

lsa file:
www.dropbox.com/s/rgmwj1pql7u4wqt/survey_archive_495263.lsa

Please Log in to join the conversation.

More
3 years 5 months ago - 3 years 5 months ago #109050 by DenisChenu
DenisChenu replied the topic: Polish special characters in open answers
OK,

For the aready set answers : same think for me, but an new answer is clean (see the screenshot).

Then surely something with the DB.
What is your DB ?
Can you look if your DB server have utf8 activated ? The lime_survey_XXX must be in utf8_unicode_ci.

PS: LimeSUrvey since 1.81 (or before ?) is used in chinese , arabic .... etc ... then polish is more easy ;)

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand (or search sondages pro).
An error happen ? Before make a new topic : remind the Debug mode .
Attachments:
Last Edit: 3 years 5 months ago by DenisChenu.

Please Log in to join the conversation.

More
3 years 5 months ago #109051 by PerOlander
PerOlander replied the topic: Polish special characters in open answers
thanks - we dont host the server ourselves, but I will forward this whole thread to those who do - hopefully this will solve it!

Please Log in to join the conversation.

More
3 years 5 months ago #109058 by PerOlander
PerOlander replied the topic: Polish special characters in open answers
for some reason it was set as latin, way back in time when the server was set up...
changing that to utf8 solved the problem, so thanks for your help!

Please Log in to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now
Join our Newsletter!