Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | |||
guides:migration-toolkit:command-line:sqlways-ini:mariadb-section [2019/11/01 08:42] alexandr.kirpichny |
guides:migration-toolkit:command-line:sqlways-ini:mariadb-section [2022/08/02 16:51] alina.svidunovich |
||
---|---|---|---|
Line 22: | Line 22: | ||
| **KEEP_INCLUDED_COLUMNS** | This option defines whether the INCLUDED columns is kept in the index definitions or not. \\ Possible values - "Yes" or "No". \\ Default value - "Yes" or Empty. | | | **KEEP_INCLUDED_COLUMNS** | This option defines whether the INCLUDED columns is kept in the index definitions or not. \\ Possible values - "Yes" or "No". \\ Default value - "Yes" or Empty. | | ||
| **VARCHAR_PAR_LEN** | This option defines the length of VARCHAR parameters when converting from Oracle to MySQL. If this option is empty, then will be used 4000 as a length of varchar parameters in MySQL. If this option is set to a some value, then this value will be used as a length of a VARCHAR parameter in MySQL. | | | **VARCHAR_PAR_LEN** | This option defines the length of VARCHAR parameters when converting from Oracle to MySQL. If this option is empty, then will be used 4000 as a length of varchar parameters in MySQL. If this option is set to a some value, then this value will be used as a length of a VARCHAR parameter in MySQL. | | ||
+ | | **SQL_MODE** | If the option is set to “ORACLE”, then the assignment statement of the appropriate system variable sql_mode is added in order to convert Oracle packages according to the logic described here https://mariadb.com/kb/en/create-package-body/. (The feature is added into MariaDB starting with 10.3.5.) \\ Possible values - “ORACLE” or Empty. \\ Default value - Empty. | | ||