Quiero codificar datos de windows1251 a utf8 usando iconv-lite.
Intento con esta función, pero recibo un error:
C:\Users\Admin\Desktop\HydroMeteoAnalyzer API\node_modules\mysql\lib\protocol\Parser.js:437 throw err; // Rethrow non-MySQL errors ^ ReferenceError: Iconv is not defined at Query.<anonymous> (C:\Users\Admin\Desktop\HydroMeteoAnalyzer API\server.js:73:9) at Query.<anonymous> (C:\Users\Admin\Desktop\HydroMeteoAnalyzer API\node_modules\mysql\lib\Connection.js:525:10) at Query._callback (C:\Users\Admin\Desktop\HydroMeteoAnalyzer API\node_modules\mysql\lib\Connection.js:491:16) at Query.Sequence.end (C:\Users\Admin\Desktop\HydroMeteoAnalyzer API\node_modules\mysql\lib\protocol\sequences\Sequence.js:83:24) at Query._handleFinalResultPacket (C:\Users\Admin\Desktop\HydroMeteoAnalyzer API\node_modules\mysql\lib\protocol\sequences\Query.js:139:8) at Query.EofPacket (C:\Users\Admin\Desktop\HydroMeteoAnalyzer API\node_modules\mysql\lib\protocol\sequences\Query.js:123:8) at Protocol._parsePacket (C:\Users\Admin\Desktop\HydroMeteoAnalyzer API\node_modules\mysql\lib\protocol\Protocol.js:291:23) at Parser._parsePacket (C:\Users\Admin\Desktop\HydroMeteoAnalyzer API\node_modules\mysql\lib\protocol\Parser.js:433:10) at Parser.write (C:\Users\Admin\Desktop\HydroMeteoAnalyzer API\node_modules\mysql\lib\protocol\Parser.js:43:10) at Protocol.write (C:\Users\Admin\Desktop\HydroMeteoAnalyzer API\node_modules\mysql\lib\protocol\Protocol.js:38:16)Yo uso esta función:
app.route('/HQstationsAHS') .get(function (req, res) { // omitted res.setHeader('content-type', 'application/json; charset=utf-8', 'Access-Control-Allow-Origin', '*', 'Cache-Control', 'private, no-cache, no-store, must-revalidate'); pool.query(`SELECT Station, Ime FROM auto_q_stations;`, function (error, result2, fields) { if (error) return res.status(500).json({ error: "Грешна заявка. Опитай отново !" }) result2 = Buffer.from(result2, 'binary'); iconv = Iconv('windows-1251', 'utf8'); result2 = iconv.convert(result2).toString(); HQstationsAHS = result2; res.json({ HQstationsAHS }) }); });¿Cómo convertir correctamente los datos?