Query output is given as csv with Windows 1252 encoding?

Josef Stolz

I'm pulling the results of a query into Power Automate and part of the result are names. Now I have german names among them so they use special characters like ö or ü. It seems to me that Raiser's Edge is giving the results of the query encoded as Windows 1252 but Power Automate interprets it as UTF-8, which creates strange things, for example "Sch?n" instead of "Schön".

Did anyone have that kind of problem with encoding, or do you know a way of either telling Query to give the results in a different format, or Power Automate that the incoming format is not UTF-8? I could also do some sort of conversion, but I didn't find anything so far.