Problem with portuguese char MS-SQL

More
2 months 1 week ago #191815 by sazevedo
Hello,

We have installed the latest version of limesurvey with this characteristics:
PHP Version 7.2.24
System Linux
MS-SQL 2014

When we create a survey with portuguese char like çã the char appears ok, but if we upload an image this char changes to ção or they disappear.
Can you help us?

thanks in advance

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

LimeSurvey Partners
More
2 months 1 week ago #191934 by fvanderstarre
You need to enable UTF-8 encoding on your MS-SQL server.
See "https://docs.microsoft.com/en-us/sql/relational-databases/collations/collation-and-unicode-support?view=sql-server-ver15" .
I don't know if that's possible for an existing database though.
Good luck!

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

More
2 months 1 week ago #191947 by Matadeleo
USE master;
GO
ALTER DATABASE MyDatabase
COLLATE utf8mb4_unicode_ci;
GO

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

More
2 months 1 week ago #192029 by sazevedo
Hi Matadeleo,

Unfortunately that collate is only for MySQL, not SQL server. :(
The following user(s) said Thank You: DenisChenu

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

More
2 months 1 week ago #192030 by sazevedo
Hi Fvanderstarre,

We are using the latin general.
It works ok if you don't upload images

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

More
2 months 1 week ago #192038 by DenisChenu
We use nvarchar for mssql : docs.microsoft.com/en-us/sql/t-sql/data-...iew=sql-server-ver15

github.com/LimeSurvey/LimeSurvey/blob/a5.../MssqlSchema.php#L11

Then some solutions : you use an old version of LimeSuvey or your server didn't accept nvarchar or transfert between SQL server and web server broke collation

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

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

More
4 weeks 1 day ago #192908 by sazevedo
Hi,

We've installed a new version with MySQL and the problem was solved.
The problem appears only with SQL server database.

Thank you for your help

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

More
4 weeks 1 day ago #192910 by DenisChenu
I use LimeSurvey on a mssql server and don't have issue with utf8 caracter with the last LTS version : github.com/LimeSurvey/LimeSurvey/commit/...24c1774493d86706233a
Please : always put the LimeSurvey version and build number

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

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!