sql - Firebird transliteration issue: conversion from utf8 client to win1252 db server

Question

I am facing a problem when trying to update data in a firebird database. Setup is the following:

• NodeJS Server with Node-Firebird module (https://github.com/hgourvest/node-firebird) --> only allows UTF8 Charset
• Firebird Server 2.5 with WIN1252 Charset (charset must also stay the same)

My update statement:

           db.transaction((err, transaction) => {
        if (err) return closeDB(db, transaction, err);
        // Update one record by pk
      console.log("do update");

      const params = [];
      
        transaction.query(`UPDATE OBJEKT
        SET BEZ = 'B?ckstra?e'
        WHERE OB_KEY = 25984`, params, (err, _) => {
            // The code below is executed only when the number of parameters is less than 10
            if (err) return closeDB(db, transaction, err);
 transaction.query('select * from OBJEKT where OB_KEY = 12345', [1], (err, data) => {
                if (err) return closeDB(db, transaction, err);
                console.log(data);
                // Finally simply commit the transaction
                closeDB(db, transaction, err);
            });
        });
    });

When doing the update queries, I am receiving "Cannot transliterate character between charsets" error. When I introduce the variable with my target charset (_win1252) the update is working, but the characters are not correct: Bockstra?e ends up as:

I started playing around with the collations, but yet no success. How can I map these 2 charsets correctly?

question from:https://stackoverflow.com/questions/65837120/firebird-transliteration-issue-conversion-from-utf8-client-to-win1252-db-server

Answer 1

Waitting for answers