Insert error: pq: unsupported Unicode escape sequence

ChirpStack Application Server
1

Hi all -

I recently enabled Postgres integration and am receiving the following error in syslog:

lora-app-server[9962]: time=“2019-09-04T21:42:26+01:00” level=error msg=“integration/multi: integration *postgresql.Integration error” error=“insert error: pq: unsupported Unicode escape sequence”

Any ideas how to troubleshoot this or what can be causing this? I’m just trying to get get any uplink error messages into postgres.

Thanks!
Mk…

2

Do any of your devices have emoji in their names? :joy:

2 Likes
3

Hello! I have the same problem! Did you solve it?

4

A good first step would be to validate the character-set configuration of your database: https://www.postgresql.org/docs/current/multibyte.html.

Then you might want to look into your PostgreSQL logs to find out what exact query is failing.

1 Like