Skip to main content

I’m having a problem with my API endpoint (both PUT and POST). It’s supposed to insert or update records in a PostgreSQL database. The database encoding is set to UTF-8, but unfortunately, any text data I send ends up stored with garbled characters (e.g. Polish letters are replaced by strange symbols).

It doesn’t matter whether I call the endpoint from postman or directly from a browser the result is the same.

Has anyone run into a similar issue? 

payload: {
  "lok_miejscowosc": "Poznań"
}

Content-Type application/json; charset=UTF-8

db result:

lok_miejscowosc|
---------------+
PoznaÅ„        |

Hi ​@kdrygalski,

Sorry to hear you’ve encountered this bug. It’s known to us and is of high priority, with a fix expected in 2025.2. The encoding issue happens on Windows when the payload is received by the Data Virtualization reader, meaning the two workarounds I can suggest are:

For your reference, this bug is known internally as FMEFLOW-25711.