I have a problem, i'm using module 'mssql' for access sql server database, but the return data not contaning accents.
Code:
'use strict';
var sql = require('mssql');
var connectionString = {
user: 'sa',
password: '******',
server: 'localhost',
port: '1433',
database: 'ConsumerData'
};
sql.connect(connectionString, function(error) {
if (error) {
throw error;
}
var request = new sql.Request();
request.query('select * from TbConsumer where Id = 1', function(err, recordset) {
console.log(recordset);
});
});
Result: [ { Id: 1, ... , FirstName: 'JoÆo Z'' } ]
The expected result: [ { Id: 1, ... , FirstName: 'João Zé' } ]
Somebody already has the problem like this?