How to Convert UTF8 to UTF8MB4
UTF8MB4 Since MySQL UTF8 supports only up to 3-byte characters, so we can't store 4-byte characters in UTF8 columns. This will be a problem for… Read More »How to Convert UTF8 to UTF8MB4
ERROR 1071 (42000)
How to Resolve ERROR 1071 (42000): Specified key was too long; max key length is 767 bytes
ERROR 1071 (42000) I got an error when creating an index. mysql> create unique index idx_name_1 on table_name (facebook_url) using btree; ERROR 1071 (42000): Specified… Read More »How to Resolve ERROR 1071 (42000): Specified key was too long; max key length is 767 bytes