Ispirer Ispirer
 

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

sqlways:command-line:sqlways-ini:mysql-section [February 04, 2019, 12:50:15 PM]
alexandr.kirpichny
sqlways:command-line:sqlways-ini:mysql-section [February 04, 2019, 12:52:22 PM] (current)
alexandr.kirpichny
Line 22: Line 22:
 | **FOREIGN_KEY_CHECKS** | This option was added to ignore foreign key constraints during LOAD DATA operation and to ignore check of data when adding FOREIGN KEY constraints to the table. Possible values - Yes, No. The default value is No. | | **FOREIGN_KEY_CHECKS** | This option was added to ignore foreign key constraints during LOAD DATA operation and to ignore check of data when adding FOREIGN KEY constraints to the table. Possible values - Yes, No. The default value is No. |
 | **CONVERT_PARTITIONS** | This option allows to convert RANGE and LIST partitions for Oracle to MySQL conversion direction. \\ Possible values - "Yes", "No" or empty. Default value - "No" or empty. | | **CONVERT_PARTITIONS** | This option allows to convert RANGE and LIST partitions for Oracle to MySQL conversion direction. \\ Possible values - "Yes", "No" or empty. Default value - "No" or empty. |
-| **CHARACTER_SET** | This option defines the encoding that will be used to store the extracted data in the files in export folder. Also according to the assigned value, this option may change the conversion of VARCHAR data type into TEXT data type. For example, when migrating from Oracle database to MySQL with utf8 encoding, maximum varchar length is different. In Oracle maximum value of VARCHAR2 is equal to 32767, and in MySQL with utf8 - 21 844. In that case If this option is set to "UTF8", all the VARCHAR2 data types, with length greater than 21 844, will be converted into TEXT in MySQL. |+| **CHARACTER_SET** | This option defines the encoding that will be used to store the extracted data in the files in export folder. \\ Also according to the assigned value, this option may change the conversion of VARCHAR data type into TEXT data type. For example, when migrating from Oracle database to MySQL with utf8 encoding, maximum varchar length is different. In Oracle maximum value of VARCHAR2 is equal to 32767, and in MySQL with utf8 it is - 21 844. So if this option is set to "UTF8", all the VARCHAR2 data types, with length greater than 21 844, will be converted into TEXT in MySQL. |
 | **SSL_CA** | This option defines the path to a file in PEM format that contains a list of trusted SSL certificate authorities. \\ Default value - Empty. | | **SSL_CA** | This option defines the path to a file in PEM format that contains a list of trusted SSL certificate authorities. \\ Default value - Empty. |
 | **SSL_MODE** | This option specifies the security state of the connection to the server. \\ Possible values - PREFERRED, DISABLED, REQUIRED, VERIFY_CA, VERIFY_IDENTITY and Empty. \\ Default value - Empty. | | **SSL_MODE** | This option specifies the security state of the connection to the server. \\ Possible values - PREFERRED, DISABLED, REQUIRED, VERIFY_CA, VERIFY_IDENTITY and Empty. \\ Default value - Empty. |
sqlways/command-line/sqlways-ini/mysql-section.txt · Last modified: February 04, 2019, 12:52:22 PM by alexandr.kirpichny
 
© 1999-2019, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement