Categories
Database MySQL

Change the Character Set & Collation of a table

To change the Character Set and Collation of a field of a table you have to use this query: if the table contains data, you have to update that data as follow:

Categories
Database Export/Import (EXPDP/IMPDP) Oracle

IMPDP Errors: ORA-02374, ORA-12899

If the Character set of source and destination database are not equal, you will see below errors in the impdp log file: to solve this error, you have to restore the structure of tables first then you have to modify these fields with alter table command as below: finally, we you have to import data […]