1.如下數據在liunx數據庫中看到正常,但匯出到csv也正常,但是拷貝到windows下看就是亂碼?
2.上傳和下載數據中一直出現分隔符 "张三\r" "张三^M",如何消除?
> db.foo.bar.find()
{
"_id": {
"$oid": "575bb9694d62257f6b000000"
},
"no": 1,
"sn": "DLXQL00UH0K0",
"status": "PASS",
"name": "张三\r"
}
{
"_id": {
"$oid": "575bb9694d62257f6b000001"
},
"no": 2,
"sn": "DLXQL012H0K0",
"status": "PASS",
"name": "李四\r"
}
{
"_id": {
"$oid": "575bb9694d62257f6b000002"
},
"no": 3,
"sn": "DLXQL01AH0K0",
"status": "FAIL",
"name": "王五\r"
}
{
"_id": {
"$oid": "575bb9694d62257f6b000003"
},
"no": 4,
"sn": "DLXQL019H0K0",
"status": "PASS",
"name": "赵六\r"
}
Return 4 row(s).
Takes 0.2240s.
但匯出到csv也正常,
no,sn,status,name
1,"DLXQL00UH0K0","PASS","张三^M"
2,"DLXQL012H0K0","PASS","李四^M"
3,"DLXQL01AH0K0","FAIL","王五^M"
4,"DLXQL019H0K0","PASS","赵六^M"
2.csv (END)
但是拷貝到windows下看就是亂碼
| no | sn | status |
1 | DLXQL00UH0K0 | PASS |
2 | DLXQL012H0K0 | PASS |
3 | DLXQL01AH0K0 | FAIL |
4 | DLXQL019H0K0 | PASS |
