View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0023891 | mantisbt | db mssql | public | 2018-01-25 23:13 | 2019-02-08 11:16 |
Reporter | Nuxunux | Assigned To | |||
Priority | normal | Severity | major | Reproducibility | always |
Status | new | Resolution | open | ||
Platform | IIS,SQL Server 2012,PHP 5.5.38 | OS | Windows Server | OS Version | 2012 R2 |
Product Version | 2.10.0 | ||||
Summary | 0023891: MSSQL 2012 can't show Chinese_Traditional | ||||
Description | MSSQL 2012 can't show Chinese_Traditional SQL Server 2012 儲存中文時皆亂碼 中文在網頁可正常顯示,但有些文字會導致顯示空白,即使將資料庫欄位改為nvarchar也無效 上傳圖片也無法使用 | ||||
Steps To Reproduce | 1) Under IIS, setup SQL Server 2012 Enterprise, PHP 5.5.38, sqlsrv | ||||
Tags | No tags attached. | ||||
Attached Files | |||||
Hi Nuxunux, I meet the same issue and fixed it. But the elder values in database is use the default characterSet (maybe ansi code), For solving the garbled issue, i coding some simple php to read the value use the default characterSet, For your reference. Hi Nuxunux, 我也遇到一樣的問題,我發現原因在php 去連線mssql 的時候沒有使用utf8 characterSet. 但因為原本資料庫裏面的繁體中文都使用預設的characterSet (可能是ansi),所以當程式修改後, 我是額外去寫了簡單的php 使用預設的characterset 把那些舊的資料都讀出來,然後自己再另外撰寫sql 去回寫回資料庫。 以上供參考。 |
|
After I modify the characterset in connect, i found i cannot upload the image anywhere. I trace the issue and I found the content column in mantis_bug_file_table, So I modify two php code and it's work.(Refer the attachment report). Otherwise, the content column in mantis_bug_file_table, it must allow Null. F.Y.R 我修改characterset 之後發生了圖片檔案無法上傳的問題。 修改內容請參考report。 另外,mantis_bug_file_table 的content 欄位必須要允許null. 以上供參考。 |
|
@samnchiu |
|