Saturday, March 18, 2017

UUID as primary key not working Laravel

We've using UUID as primary key in laravel, I've created a record and its working but I've unable to get this record with UUID.

Table:

CREATE TABLE `User` (
  `uuid` binary(16) NOT NULL ,
  `name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`uuid`),
) ;

Laravel code:

Model:

class User extends Model {
    const UPDATED_AT = 'updated';
    protected $table = 'user';
    protected $primaryKey = 'uuid';
    protected $incremental = false;
}

Controller:

$contact = User::find(hex2bin('11E7094BFDB648529F5F7429AF41FD58'));

But result is always Null. :(

Thanks!



via Govind Samrow

Advertisement