Russian language Survey

More
3 months 9 hours ago #172528 by prasan_3105
prasan_3105 created the topic: Russian language Survey
One of our users were trying to create a survey which had some Russian language questions which are displayed as question marks.
We have checked Database the collation of the database is Latin1_General_CI_AS and it supports unicode characters.
Our requirement we want to have one database which should support all the languages.
If any application level/code level changes are required for this please let us know.

Please Log in or Create an account to join the conversation.

More
3 months 8 hours ago #172535 by LouisGac
LouisGac replied the topic: Russian language Survey
update to latest version.
we recently updated Roboto to extended Latin for Polish users.
you can also use the font 'Noto' (in theme options)
The following user(s) said Thank You: prasan_3105

Please Log in or Create an account to join the conversation.

More
2 months 4 weeks ago #172584 by prasan_3105
prasan_3105 replied the topic: Russian language Survey
Dear,
Thank you for the quick update. If we want to go with latest version do we need to perform all the installation again including DB or it is just copying application files
We have already Lime survey 2.5 version running.

Please advise.

Please Log in or Create an account to join the conversation.

More
2 months 4 weeks ago #172585 by LouisGac
LouisGac replied the topic: Russian language Survey
upgrade from 2.5 to 3 is a major one, breaking survey templates customization and plugins.
you can upgrade safely if you're not using a custom template or plugins. else it could be complexe.

a very easy way to fix the problem in 2.5 would be to update the CSS of your template so it use browser font, like default sans serif one.

Please Log in or Create an account to join the conversation.

More
2 months 4 weeks ago #172586 by prasan_3105
prasan_3105 replied the topic: Russian language Survey
There are not much customizations - As per your advise do we need to copy the application files ?
No DB changes required ? Please confirm

Please Log in or Create an account to join the conversation.

More
2 months 3 weeks ago #172767 by prasan_3105
prasan_3105 replied the topic: Russian language Survey
Dear Team,
We have upgraded the version to 3.14 -still when we create a survey using below options
1. Survey Base language - Russian
2. Questions we are providing in Russian
But when we save the survey all the questions is displayed in question marks.
Could you please help.

Please Log in or Create an account to join the conversation.

More
2 months 3 weeks ago #172771 by jelo
jelo replied the topic: Russian language Survey
You should open a bugticket with information about your setup.
You can perhaps paste it here too. Click on the Version number at the botton. A screen should popup with infos about your system.

To me this sounds like an issue which is related to the database/table creation.
What database server and version is used? Microsoft SQL Server?

Are you a student conducting a survey? If yes, tell me why you use LimeSurvey?
www.limesurvey.org/forum/development/116...y-you-use-limesurvey

Please Log in or Create an account to join the conversation.

More
2 months 3 weeks ago #172773 by prasan_3105
prasan_3105 replied the topic: Russian language Survey
Thank you for the quick update
Below are the details
Your system configuration:
LimeSurvey version :3.14.5
LimeSurvey build:180815
Operating system:Linux lxlstapd01 3.8.13-118.21.4.el6uek.x86_64 #2 SMP Thu Jun 14 18:37:47 PDT 2018 x86_64
PHP version:7.0.14
Web server name:limesurveyisd.toyota-europe.com
Web server software:Apache/2.2.31 (Unix) PHP/7.0.14
Web server info:
Database driver:dblib
Database driver version:SQLSTATE[IM001]: Driver does not support this function: driver does not support that attribute
Database server info:SQLSTATE[IM001]: Driver does not support this function: driver does not support that attribute
Database server version:SQLSTATE[IM001]: Driver does not support this function: driver does not support that attribute

MS SQLSERVER 2012 SP3 collation Latin1_General_CI_AS

Please Log in or Create an account to join the conversation.

More
2 months 3 weeks ago #172786 by jelo
jelo replied the topic: Russian language Survey

prasan_3105 wrote: MS SQLSERVER 2012 SP3 collation Latin1_General_CI_AS


OK, you got a OracleLinux 6, Apache, PHP server with Limesurvey installed and a dedicated MS SQL Server.


If it isn't a specific LimeSurvey bug, I see two areas to investigate.

1.) MSSQL driver for php linux. I'm not using Oracle Linux 6 (it's a derivative of RHEL6).
There are different drivers to connect to SQLServer.

Warning. Don't just use these lines. You may need to adapt them to your environment.
sudo pecl install sqlsrv pdo_sqlsrv
sudo echo "extension= pdo_sqlsrv.so" >> `php --ini | grep "Loaded Configuration" | sed -e "s|.*:\s*||"`
sudo echo "extension= sqlsrv.so" >> `php --ini | grep "Loaded Configuration" | sed -e "s|.*:\s*||"`


2.) I would create a new database and install another LimeSurvey LS 3, to see if different issues or no issues occurs. Will speed up things for you. If you got no issue, you can narrow the issue to database/tables and LimeSurvey config.

I still recommend to open a bugticket.

Since I don't use this environment, it is an educated guess.

Are you a student conducting a survey? If yes, tell me why you use LimeSurvey?
www.limesurvey.org/forum/development/116...y-you-use-limesurvey

Please Log in or Create an account to join the conversation.

More
2 months 3 weeks ago - 2 months 3 weeks ago #172807 by LouisGac
LouisGac replied the topic: Russian language Survey
prasan_3105, in 3.14 you can use the theme options to change the fonts. Just use one of the "browser fonts", they will work with any language.
Last Edit: 2 months 3 weeks ago by LouisGac.

Please Log in or Create an account to join the conversation.

More
2 months 3 weeks ago #172813 by jelo
jelo replied the topic: Russian language Survey
Just in case others are looking for the bugreport.
bugs.limesurvey.org/view.php?id=13989


When I look at this screenshot I don't see a direct relation to Surveytheme (and options of fonts).

This can get quite nasty, when you have mixed coded content in a database.

The workflow Browser -> Database Client -> Database Server -> Table can alter coding of content at serveral points. And a Linux -> SQL Server workflow isn't making it easier.

Are you a student conducting a survey? If yes, tell me why you use LimeSurvey?
www.limesurvey.org/forum/development/116...y-you-use-limesurvey
Attachments:

Please Log in or Create an account to join the conversation.

More
2 months 3 weeks ago #172825 by LouisGac
LouisGac replied the topic: Russian language Survey
for backend just choose NOTO in the list of admin themes.
should work.

I don't think the problem will be in DB, we didn't made any change in DB collation since a long time, and it's UTF8mb4:

wpml.org/forums/topic/russian-characters-are-saved-as/

It is the case since db 257
github.com/LimeSurvey/LimeSurvey/blob/ma...lper.php#L1329-L1347

Also, I'm right now watching about updating Roboto. The problem is that adding all the alphabet to it would make it huge. So I'm thinking about a way to fix it without making it to heavy for frontend, without breaking existing themes, etc

I think I will add a "Roboto Light" font as an option.

Please Log in or Create an account to join the conversation.

More
2 months 3 weeks ago - 2 months 3 weeks ago #172826 by jelo
jelo replied the topic: Russian language Survey

LouisGac wrote: I don't think the problem will be in DB, we didn't made any change in DB collation since a long time, and it's UTF8mb4:

I still won't ruleout that the issue is not related to LS directly, but lays in the setup of database and access libraries (OS+PHP binaries). The issue occurs, when first using the different language, which demands a broader charset. For bugreports it is important, to know, if the user is already using the language or not. Here it is first time usage.

The japanese bug report seems to contradict my idea with the database.
bugs.limesurvey.org/view.php?id=13904
Some fields are correctly shown. Some not. Perhaps different tables?

Are you a student conducting a survey? If yes, tell me why you use LimeSurvey?
www.limesurvey.org/forum/development/116...y-you-use-limesurvey
Last Edit: 2 months 3 weeks ago by jelo.

Please Log in or Create an account to join the conversation.

More
2 months 3 weeks ago #172829 by LouisGac
LouisGac replied the topic: Russian language Survey
The japanes issue could be pretty different than the russian one: needs more testing.

Please Log in or Create an account to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now
Join our Newsletter!