How to Convert UTF8 to UTF8MB4December 28, 2014December 9, 2022UTF8MB4 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
How to Resolve ERROR 1071 (42000): Specified key was too long; max key length is 767 bytesDecember 25, 2014December 9, 2022ERROR 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