Welcome to the LimeSurvey Community Forum

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

Russian language Survey

  • prasan_3105
  • prasan_3105's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
5 years 7 months ago #172528 by prasan_3105
Russian language Survey was created by prasan_3105
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.
The topic has been locked.
  • LouisGac
  • LouisGac's Avatar
  • Visitor
  • Visitor
5 years 7 months ago #172535 by LouisGac
Replied by LouisGac on 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 topic has been locked.
  • prasan_3105
  • prasan_3105's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
5 years 7 months ago #172584 by prasan_3105
Replied by prasan_3105 on 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.
The topic has been locked.
  • LouisGac
  • LouisGac's Avatar
  • Visitor
  • Visitor
5 years 7 months ago #172585 by LouisGac
Replied by LouisGac on 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.
The topic has been locked.
  • prasan_3105
  • prasan_3105's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
5 years 7 months ago #172586 by prasan_3105
Replied by prasan_3105 on 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
The topic has been locked.
  • prasan_3105
  • prasan_3105's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
5 years 7 months ago #172767 by prasan_3105
Replied by prasan_3105 on 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.
The topic has been locked.
More
5 years 7 months ago #172771 by jelo
Replied by jelo on 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?

The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
The topic has been locked.
  • prasan_3105
  • prasan_3105's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
5 years 7 months ago #172773 by prasan_3105
Replied by prasan_3105 on 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
The topic has been locked.
More
5 years 7 months ago #172786 by jelo
Replied by jelo on 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.
Code:
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.

The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
The topic has been locked.
  • LouisGac
  • LouisGac's Avatar
  • Visitor
  • Visitor
5 years 7 months ago - 5 years 7 months ago #172807 by LouisGac
Replied by LouisGac on 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: 5 years 7 months ago by LouisGac.
The topic has been locked.
More
5 years 7 months ago #172813 by jelo
Replied by jelo on 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.

The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
The topic has been locked.
  • LouisGac
  • LouisGac's Avatar
  • Visitor
  • Visitor
5 years 7 months ago #172825 by LouisGac
Replied by LouisGac on 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.
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose