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.

update to latest version.
we recently updated Roboto to extended Latin for Polish users.
you can also use the font 'Noto' (in theme options)

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.

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.

There are not much customizations - As per your advise do we need to copy the application files ?
No DB changes required ? Please confirm

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.

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?

Thank you for the quick update
Below are the details
Your system configuration:
LimeSurvey version .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

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.

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.

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.

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.