View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000290 | tracker | data servicing | public | 2019-07-08 16:47 | 2019-07-11 17:52 |
| Reporter | DigitalMy | ||||
| Priority | normal | Severity | minor | Reproducibility | have not tried |
| Status | assigned | Resolution | open | ||
| Product Version | |||||
| Fixed in Version | |||||
| Summary | 0000290: Update SQL server (MicroSoft) to version 2019 for UTF-8 support | ||||
| Description | Collate mantis DB to UTF8 , after that import japanese texts from MySQL DB | ||||
| Tags | No tags attached. | ||||
| FinishDate | |||||
| LaboriousnessIndex | 5 | ||||
| PriorityIndex | 5 | ||||
| StartDate | |||||
| WasteTime | 0 | ||||
|
|
As found in MicroSoft documents, use Unicode data types (nchar, nvarchar, and ntext) instead of non-Unicode data types (char, varchar, and text). We have in [name] field broken imported characters FROM [mantis].[dbo].[mantis_tag_table] type varchar , that is wrong... |
|
|
recreated table with unicode fields, imported again -> studio showed correct lang, but mantis interface shows ??? again , same non-unicode output found in function compat_db_query |
|
|
../adodb/adodb-php/adodb.inc.php has function setConnectionParameter($parameter,$value) , which never used... but it can set for mssqlnative driver ('CharacterSet','UTF-8') http://adodb.org/dokuwiki/doku.php?id=v5:reference:connection:setconnectionparameter Fix: add line $g_db->setConnectionParameter('CharacterSet','UTF-8'); after line $g_db = ADONewConnection( $t_db_type ); in file core/database_api.php (this is function db_connect) |