Cannot inline-edit row when table has VARCHAR primary key
Database management in a single PHP file
Brought to you by:
jakubvrana
Menu
▾
▴
#439 Cannot inline-edit row when table has VARCHAR primary key
When trying to inline edit row with VARCHAR(64) primary key, then generated query fails:
COLLATION 'utf8mb4_bin' is not valid for CHARACTER SET 'utf8' 10:43:40 SQL command
UPDATE session SET state = 'NEW' WHERE session_id = '0002486d-5de5-4abf-8342-294b519a81f8' AND session_id = '0002486d-5de5-4abf-8342-294b519a81f8' COLLATE utf8mb4_bin;
MySQL version: 5.6.19-log through PHP extension MySQLi
I'll address this together with bug #438.