Russian language Survey

More
1 year 11 months ago #172528 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.
LimeSurvey Partners
  • LouisGac
  • LouisGac's Avatar
  • Visitor
  • Visitor
1 year 11 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.
More
1 year 11 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
1 year 11 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.
More
1 year 11 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.
More
1 year 11 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
1 year 11 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.
  • LouisGac
  • LouisGac's Avatar
  • Visitor
  • Visitor
1 year 11 months ago - 1 year 11 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: 1 year 11 months ago by LouisGac.
The topic has been locked.
  • LouisGac
  • LouisGac's Avatar
  • Visitor
  • Visitor
1 year 11 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.
  • LouisGac
  • LouisGac's Avatar
  • Visitor
  • Visitor
1 year 11 months ago #172829 by LouisGac
Replied by LouisGac on topic Russian language Survey
The japanes issue could be pretty different than the russian one: needs more testing.
The topic has been locked.

Start now!

Just create your account and start using Limesurvey today.

Register now