Storing uuid byte sequence to postgres.
Author: N-ZaaijerCreated Aug 24, 2017Updated Mar 8, 2021
Labelsdocumentation
Hi,
I'm currently having problems to store the optimized byte sequence to my postgres database. I keep getting the error SQLSTATE[22021]: Character not in repertoire: 7 ERROR: invalid byte sequence for encoding "UTF8": 0xe7 0x87 0xf3
I've followed the guide and used the OrderedTimeCodec in my uuid factory.
My database table alteration script: DB::statement('ALTER TABLE entity_groups ADD uuid bytea');
I'm using php 7.1, laravel 5.4 and postgres 9.4.
Thanks in advance.
Source: ramsey/uuid