Garbled Text in PL/SQL Developer
Garbled Text We saw unreadable result in PL/SQL Developer after we INSERT INTO 3 rows and SELECT the table. We checked the language of this… Read More »Garbled Text in PL/SQL Developer
AL32UTF8
How to Resolve ORA-28232: invalid input length for obfuscation toolkit
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
How to Resolve ORA-12899: value too large for column
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. What… Read More »How to Resolve ORA-12899: value too large for column
Alter Database Character Set AL32UTF8 Directly?
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?
How Oracle Change Character Set
Assuming that you have exported all the data to dump files for later processes. Database Character Set Check current setting on character sets. SQL> column… Read More »How Oracle Change Character Set