i have an application (NextJS/NestJS) connected with psql database. There’s a form that user fills which works fine until i type a char like “é” in input and send the form to server, psql says invalid byte sequence for encoding “UTF8”: 0xe8 0x6d 0x65 . My server / client encodings are UTF-8. This problem is gone when i restart the server but comes back after sending successfully multiple forms that contains letter ‘é’. So it comes randomly without any specific trigger from our end.
I tried to insert into database using nestjs typeorm a string that contains special french letters like “é”, it works at the beginning perfectly fine then suddenly it stops working until i restart my application, endless loop. but when problem occurs i tried to insert directly to postgres through psql CLI and it works! so i think the problem is with the application end (nestjs+typeorm)
5