Relative Content

Tag Archive for postgresqlnestjstypeorm

invalid byte sequence for encoding “UTF8”: 0xe8 0x6d 0x65

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.

How to limit children while left joining in typeorm?

I’m using TypeORM with PostgreSQL in my Nest.js application. I have two entities, User and Photo, with a one-to-many relationship (one user can have multiple photos). I’m trying to retrieve users along with at most 5 photos for each user using TypeORM’s query builder.