S贸stenes Apollo
S贸stenes Apollo
This version @Jolg42 `"@prisma/client": "^3.15.2"` ``` prisma : 3.15.2 @prisma/client : 3.15.2 Current platform : darwin-arm64 Query Engine (Node-API) : libquery-engine 461d6a05159055555eb7dfb337c9fb271cbd4d7e (at node_modules/@prisma/engines/libquery_engine-darwin-arm64.dylib.node) Migration Engine : migration-engine-cli 461d6a05159055555eb7dfb337c9fb271cbd4d7e (at...
@NikitaMasl I got a workaround, `creating a field` in the Postgres table with the filter/filters I need without accentuation
@NikitaMasl yeah, I've tried everything you can imagine, and it seems to be a prisma limitation
I think if you switch to mysql you'll be able to run with your custom collation or something like this
@NikitaMasl I found a workarround using chatGTP lol
This was his answer And my implementation: ``` const name = 'S贸stenes Apollo'; const filterText = removeAccents(`%${name}%`).toLowerCase(); console.log('Filter text', filterText); this.prisma.$queryRaw`select id, name from users where LOWER(unaccent(name)) LIKE ${filterText};`.then((users) =>...
`CREATE EXTENSION unaccent;` You should use this command if you're using postgres.
@agustin-sanc that's not the solution, workarround, but for a large database it doesn't work, data duplicity
Mine is connecting, but not receiving the messages in the server