Unicode translation to SQL_ASCII encoding fails with tempature, winddirection and cubic-meter-gas unit_of_measurement

[hahu66]

Hi,

First of all I am very happy to with LTSS.
Using a PostgreSQL database instead of InfluxDB, to be able to hook up other data visualization tools (like Tableau), and maintain possibility for Grafana (examples by the HA community).

It was easy to setup, with a LXC container with Proxmox Helper script.
Most difficult part was to find and select the domains and/or entitities to include or exclude.

Running for a couple of hours now, i decided to check the logs.
It is working pretty well and data is moved to PostgreSQL/TimeScale.

But it fails with sensors with special characters to encode from Unicode to SQL_ASCII.
Error Message:

DETAIL:  Unicode escape value could not be translated to the server's encoding SQL_ASCII.
CONTEXT:  JSON data, line 1: ..., "voltage": 3025, "unit_of_measurement": "\u00b0...

Where unit_of_measument can be '°C' (degrees Celsius), winddirection '°' or cubic-meter gas in 'm³'.
I also drive a Skoda for which i use the skoda_connect integration to get data into HA.
And the name is officially: Škoda, with that 'strange' S.
The are quite a lot devices with a temperature entity, which i would not like to miss in LTSS.

Is there a solution for this?

[hahu66]

Fixed it: database was created with ASCII (by default) and not UTF8.