View Issue Details

IDProjectCategoryView StatusLast Update
0020595mantisbtdb mssqlpublic2016-02-21 07:48
ReporterclevertiQA Assigned Toatrol  
PriorityhighSeveritymajorReproducibilityalways
Status closedResolutionno change required 
OSWindows Server 2012 
Product Version1.2.19 
Summary0020595: Unable to see latin chars on Mantis 1.2.19 with SQL Server
Description

After installing Mantis 1.2.19 (just copy to the wwwroot dir) and run a script to create the database schema and data in SQL Server 2012 from a MySQL database, I can login in the Mantis without any problem, but some charcters are not showing up or are showing up incorrectly.

This only happens to data fetched from the database, where special portuguese characters (like: 'ç', 'ã') are replaced by other characters or fields are left blank.

Steps to reproduce:
1 - Setup an environment with Windows Server 2012 + IIS 8.5 + PHP 5.6
2 - Install Mantis 1.2.19 (just extract zip to a folder on wwwroot)
3 - Create MSSQLServer 2012 database for Mantis (I tried a clena installation but he didn't work)
4 - Create something (project, user, etc) using portuguese characters

TagsNo tags attached.

Activities

clevertiQA

clevertiQA

2016-02-10 12:13

reporter   ~0052508

This issue is related to forum topic https://www.mantisbt.org/forums/viewtopic.php?f=3&t=23593

atrol

atrol

2016-02-11 01:55

developer   ~0052511

clevertiQA,

Migrating the database to utf-8 before importing might fix the issue.
https://www.mantisbt.org/wiki/doku.php/mantisbt:upgrade_to_utf8

This is not a bug or feature request for MantisBT (you are asking for help on how to deal with problems that you introdcued by migrating data from MySQL to SQL-Server
). I am therefore resolving this issue as "no change required".

Please use the forums, the mantisbt-help mailing list or IRC to get support on customizing and using MantisBT (refer to http://www.mantisbt.org/support.php for links and further details).

Seems you don't want to follow my advice ;-) https://www.mantisbt.org/forums/viewtopic.php?f=3&t=23593#p58716