Select not returning when using accentuation

[LuizGMX]

I'm trying to use a word with accentuation in my WHERE clause but it's not working.
And when I retrieve data that cotains a word with accentuation i always get "�" in place.

[charmander]

Please show the relevant code and output, and, if possible, a minimal script to reproduce the problem.

[LuizGMX]

router.get("/filtraEspecialidade", function (req, res) {
// tipo = req.query.tipo;
//var campoConvenio = req.query.campoConvenio;

//console.log('tipo: ' + tipo);
//console.log('convenio: ' + campoConvenio);
//console.log('pagamento: '+modalidade_pagamento);
//  Query uses the value from the url.

async function listaEspecialidades() {

    await db.connect()

    var result;
    result = await db.query(`
SELECT te.des_especialidade 
FROM arq_medico am
INNER JOIN arq_medico_especialidade ame ON ame.id_medico = am.id_medico
INNER JOIN tab_especialidade te ON te.id_especialidade = ame.id_especialidade
WHERE am.ind_status = 'Ativo' AND EXISTS (SELECT 1 FROM arq_agendap WHERE am.id_medico = arq_agendap.id_medico LIMIT 1) 

`)

    //console.log(result.rows);
    res.send(result.rows);

}

listaEspecialidades();

});

[charmander]

Where are the accents? Where is the output?

Anyway, respond with the encoding you’re sending:

res.set('Content-Type', 'text/plain; charset=utf-8')

[LuizGMX]

Here's the output

[LuizGMX]

[LuizGMX]

Any help?

[charmander]

Can you show the results of that query using another tool, like psql? Are they correct in that case?

[LuizGMX]

yes it's correct, see:

[LuizGMX]

Hi, can someone help me?

[boromisp]

Please execute the following queries both in node.js, and in the environment that returns the expected characters (pgAdmin?) and show us the results.

SHOW client_encoding;
SHOW server_encoding;

[LuizGMX]

[LuizGMX]

Any help?

[LuizGMX]

Someone?