How to Resolve ORA-12899: value too large for column

Posted on
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 see how I found ORA-12899 when I migrated some tables from one database (UTF8) to another (AL32UTF8). SQL> INSERT INTO “ERPAPP”.”FIN_NORTH_HIST”@ORA12C SELECT * FROM “ERPAPP”.”FIN_NORTH_HIST”; INSERT INTO “ERPAPP”.”FIN_NORTH_HIST”@ORA12C SELECT * […]

How to Fix Garbled Filename and Text

Posted on
There’re several ways to display your garbled filename correctly. LANG Environment Variable PuTTY Character Set Rename Badly Encoded Filename A. LANG Environment Variable Tried to list a file which name is made by a multi-byte language like this. [root@test ~]# ll total 8 -rw-r–r–  1 root root  217 Oct 17 00:39 ▒?▒▒?▒▒?▒.txt … This is […]

How to Resolve ERROR 1366 (HY000): Incorrect string value

Posted on
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 row 1In the above statement, we were trying to set a column value with a 4-byte character, but it failed with ERROR 1366.Since the table is based on UTF8 that […]