javascript - jQuery DataTables CSV 导出 utf-8

Question

我想将数据表导出为 CSV。如何指定utf-8编码？

http://jsfiddle.net/ebRXw/3058/

Mamadou Diôf 导出后成为 Mamadou Di´f

我尝试添加 "bom":true 但问题仍然存在

Answer 1

将 bom 放入 csv 扩展选项中:

$(document).ready(function() { 
var dataSet = [
[ "Tiger Nixon", "System Architect", "Edinburgh", "5421", "2011/04/25", "$320,800" ],
[ "Garrett Winters", "Accountant", "Tokyo", "8422", "2011/07/25", "$170,750" ],
[ "Mamadou Diôf", "Junior Technical Author", "San Francisco", "1562", "2009/01/12", "$86,000" ]
];

$('#example').DataTable( {
    dom: 'Bfrtip',
    data: dataSet,
    columns: [
        { title: "Name" },
        { title: "Position" },
        { title: "Office" },
        { title: "Extn." },
        { title: "Start date" },
        { title: "Salary" }
    ],
    buttons: [
        {
           extend: 'csv',
           charset: 'UTF-8',
           fieldSeparator: ';',
           bom: true,
           filename: 'CsvTest',
           title: 'CsvTest'
        }
    ]
});
});