We are doing impact analysis on the new type AFTER convert from Oracle 10g/12c to to MariaDB, any information on
1) Is there any impact on the change of type ( in terms of RAM, disk space and CPU) ?
2) What to do to get ride of the impact?
3) URL for the proof?
For the following type conversion:
NUMBER(10,0) and NUMBER (9,0) convert to BIGINT
NUMBER(3,0) convert to SMALLINT
NUMBER(1,0) convert to TINYINT.
NUMBER without () (e.g. NUMBER) to DOUBLEe
DATE to DATETIME
VARCHAR2() to VARCHAR() (e.g. VARCHAR2(1 CHAR) will become VARCHAR(1). VARCHAR2(100 CHAR) will become VARCHAR(100)