Unique Index Reject Distinct Row?
We all know unique constraints reject only duplicated rows from inserting into the database, but in this case, one of my unique indexes also rejects… Read More »Unique Index Reject Distinct Row?
UTF8
How to Resolve ERROR 1366 (HY000): Incorrect string value
ERROR 1366 (HY000) Let's see how will this error happen: mysql> update zh_table set zh_name = '๐คจ' where id = 35620; ERROR 1366 (HY000): Incorrect string value:… Read More »How to Resolve ERROR 1366 (HY000): Incorrect string value
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
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
How to Create Databases with Names Containing Special Characters
MySQL allows you to create databases with names containing special characters. But if you create it without taking care of the name, it will fail… Read More »How to Create Databases with Names Containing Special Characters