ORA-28232 Developers tried to obfuscate data by DBMS_OBFUSCATION_TOOLKIT in a database with multi-byte character set and got this error. ORA-28232: invalid input length for obfuscation… Read More »How to Resolve ORA-28232: invalid input length for obfuscation toolkit
ORA-12899 ORA-12899 means that the value of being inserted or updated data is larger than column's allowable length that is defined in the table. Let's… Read More »How to Resolve ORA-12899: value too large for column
Can I Change Current Character Set into AL32UTF8 without Converting Data? The direct answer is, if they are in subset-superset relationship, you can change the… Read More »Alter Database Character Set AL32UTF8 Directly?
I am not exaggerating the size of the problem. You may think all the non-duplicated rows can always pass through the check from unique constraints… Read More »MySQL Unique Indexs May Prevent Non-duplicated Row From Insert
Let's see how will this error happen:mysql> update zh_table set zh_name = '𤨒' where id = 35620;ERROR 1366 (HY000): Incorrect string value: 'xF0xA4xA8x92...' for column 'zh_name' at… Read More »How to Resolve ERROR 1366 (HY000): Incorrect string value
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 serving… Read More »How to Convert an Entire Database From UTF8 to UTF8MB4
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 key was too long; max… Read More »How to Resolve ERROR 1071 (42000): Specified key was too long; max key length is 767 bytes