MySQL Mysql db.mysql 64 com.mysql.rdbms.mysql.driver.native db.mysql.Schema ALL CREATE DROP GRANT OPTION REFERENCES EVENT db.mysql.Table ALL CREATE DROP GRANT OPTION REFERENCES ALTER DELETE INDEX INSERT SELECT UPDATE TRIGGER LOCK TABLES db.mysql.View ALL CREATE VIEW SHOW VIEW DROP REFERENCES ALTER DELETE INDEX INSERT SELECT UPDATE TRIGGER db.mysql.Routine ALL ALTER ROUTINE CREATE ROUTINE EXECUTE big5_chinese_ci big5_bin big5_chinese_ci Big5 Traditional Chinese big5 com.mysql.rdbms.mysql dec8_swedish_ci dec8_bin dec8_swedish_ci DEC West European dec8 com.mysql.rdbms.mysql cp850_general_ci cp850_bin cp850_general_ci DOS West European cp850 com.mysql.rdbms.mysql hp8_english_ci hp8_bin hp8_english_ci HP West European hp8 com.mysql.rdbms.mysql koi8r_general_ci koi8r_bin koi8r_general_ci KOI8-R Relcom Russian koi8r com.mysql.rdbms.mysql latin1_german1_ci latin1_swedish_ci latin1_danish_ci latin1_german2_ci latin1_bin latin1_general_ci latin1_general_cs latin1_spanish_ci latin1_swedish_ci ISO 8859-1 West European latin1 com.mysql.rdbms.mysql latin2_czech_cs latin2_general_ci latin2_hungarian_ci latin2_croatian_ci latin2_bin latin2_general_ci ISO 8859-2 Central European latin2 com.mysql.rdbms.mysql swe7_swedish_ci swe7_bin swe7_swedish_ci 7bit Swedish swe7 com.mysql.rdbms.mysql ascii_general_ci ascii_bin ascii_general_ci US ASCII ascii com.mysql.rdbms.mysql ujis_japanese_ci ujis_bin ujis_japanese_ci EUC-JP Japanese ujis com.mysql.rdbms.mysql sjis_japanese_ci sjis_bin sjis_japanese_ci Shift-JIS Japanese sjis com.mysql.rdbms.mysql hebrew_general_ci hebrew_bin hebrew_general_ci ISO 8859-8 Hebrew hebrew com.mysql.rdbms.mysql tis620_thai_ci tis620_bin tis620_thai_ci TIS620 Thai tis620 com.mysql.rdbms.mysql euckr_korean_ci euckr_bin euckr_korean_ci EUC-KR Korean euckr com.mysql.rdbms.mysql koi8u_general_ci koi8u_bin koi8u_general_ci KOI8-U Ukrainian koi8u com.mysql.rdbms.mysql gb2312_chinese_ci gb2312_bin gb2312_chinese_ci GB2312 Simplified Chinese gb2312 com.mysql.rdbms.mysql greek_general_ci greek_bin greek_general_ci ISO 8859-7 Greek greek com.mysql.rdbms.mysql cp1250_general_ci cp1250_czech_cs cp1250_croatian_ci cp1250_bin cp1250_general_ci Windows Central European cp1250 com.mysql.rdbms.mysql gbk_chinese_ci gbk_bin gbk_chinese_ci GBK Simplified Chinese gbk com.mysql.rdbms.mysql latin5_turkish_ci latin5_bin latin5_turkish_ci ISO 8859-9 Turkish latin5 com.mysql.rdbms.mysql armscii8_general_ci armscii8_bin armscii8_general_ci ARMSCII-8 Armenian armscii8 com.mysql.rdbms.mysql utf8_general_ci utf8_bin utf8_unicode_ci utf8_icelandic_ci utf8_latvian_ci utf8_romanian_ci utf8_slovenian_ci utf8_polish_ci utf8_estonian_ci utf8_spanish_ci utf8_swedish_ci utf8_turkish_ci utf8_czech_ci utf8_danish_ci utf8_lithuanian_ci utf8_slovak_ci utf8_spanish2_ci utf8_roman_ci utf8_persian_ci utf8_hungarian_ci utf8_general_ci UTF-8 Unicode utf8 com.mysql.rdbms.mysql ucs2_general_ci ucs2_bin ucs2_unicode_ci ucs2_icelandic_ci ucs2_latvian_ci ucs2_romanian_ci ucs2_slovenian_ci ucs2_polish_ci ucs2_estonian_ci ucs2_spanish_ci ucs2_swedish_ci ucs2_turkish_ci ucs2_czech_ci ucs2_danish_ci ucs2_lithuanian_ci ucs2_slovak_ci ucs2_spanish2_ci ucs2_roman_ci ucs2_persian_ci ucs2_general_ci UCS-2 Unicode ucs2 com.mysql.rdbms.mysql cp866_general_ci cp866_bin cp866_general_ci DOS Russian cp866 com.mysql.rdbms.mysql keybcs2_general_ci keybcs2_bin keybcs2_general_ci DOS Kamenicky Czech-Slovak keybcs2 com.mysql.rdbms.mysql macce_general_ci macce_bin macce_general_ci Mac Central European macce com.mysql.rdbms.mysql macroman_general_ci macroman_bin macroman_general_ci Mac West European macroman com.mysql.rdbms.mysql cp852_general_ci cp852_bin cp852_general_ci DOS Central European cp852 com.mysql.rdbms.mysql latin7_estonian_cs latin7_general_ci latin7_general_cs latin7_bin latin7_general_ci ISO 8859-13 Baltic latin7 com.mysql.rdbms.mysql cp1251_bulgarian_ci cp1251_ukrainian_ci cp1251_bin cp1251_general_ci cp1251_general_cs cp1251_general_ci Windows Cyrillic cp1251 com.mysql.rdbms.mysql cp1256_general_ci cp1256_bin cp1256_general_ci Windows Arabic cp1256 com.mysql.rdbms.mysql cp1257_lithuanian_ci cp1257_bin cp1257_general_ci cp1257_general_ci Windows Baltic cp1257 com.mysql.rdbms.mysql binary binary Binary pseudo charset binary com.mysql.rdbms.mysql geostd8_general_ci geostd8_bin geostd8_general_ci GEOSTD8 Georgian geostd8 com.mysql.rdbms.mysql cp932_japanese_ci cp932_bin cp932_japanese_ci SJIS for Windows Japanese cp932 com.mysql.rdbms.mysql eucjpms_japanese_ci eucjpms_bin eucjpms_japanese_ci UJIS for Windows Japanese eucjpms com.mysql.rdbms.mysql Standard (TCP/IP) MigrationGeneric QueryMysql ReverseEngineeringMysql TransformationMysql MySQL native driver using the MySQL client library http://dev.mysql.com/downloads/mysql/ libmysql.dll . 0 1 mysqlcppconn MysqlNative com.mysql.rdbms.mysql Hostname: 127.0.0.1 Name or IP address of the server host 0 1 118 hostName com.mysql.rdbms.mysql.driver.native string 1 Port: 3306 TCP/IP port 0 1 46 port com.mysql.rdbms.mysql.driver.native int 1 Username: root Name of the user to connect with. 0 2 218 userName com.mysql.rdbms.mysql.driver.native string 1 Password: The user's password. 0 3 218 %userName%::Mysql@%hostName%:%port% com.mysql.rdbms.mysql.driver.native keychain 0 Default Schema: The schema that will be used as default schema 0 4 218 getSchemata ReverseEngineeringMysql schema com.mysql.rdbms.mysql.driver.native string 0 Use compression protocol Select this option for WAN connections. 1 -1 318 CLIENT_COMPRESS com.mysql.rdbms.mysql.driver.native boolean 0 Use ANSI quotes to quote identifiers. If enabled this option overwrites the serverside settings. 1 -1 318 useAnsiQuotes com.mysql.rdbms.mysql.driver.native tristate 0 Read Timeout. 600 OPT_READ_TIMEOUT 1 -1 318 OPT_READ_TIMEOUT com.mysql.rdbms.mysql.driver.native int 0 Use SSL if available This option turns on SSL encryption if the client library supports it 1 -1 318 useSSL com.mysql.rdbms.mysql.driver.native boolean 0 SSL CA File: Path to Certificate Authority file for SSL. 1 -1 180 sslCA com.mysql.rdbms.mysql.driver.native string 0 SSL CERT File: Path to Certificate file for SSL. 1 -1 180 sslCert com.mysql.rdbms.mysql.driver.native string 0 SSL Key File: Path to Key file for SSL. 1 -1 180 sslKey com.mysql.rdbms.mysql.driver.native string 0 SSL Cipher: Optional list of permissible ciphers to use for SSL encryption. 1 -1 180 sslCipher com.mysql.rdbms.mysql.driver.native string 0 Local Socket/Pipe MigrationGeneric QueryMysql ReverseEngineeringMysql TransformationMysql MySQL native driver using the MySQL client library http://dev.mysql.com/downloads/mysql/ libmysql.dll . 0 1 mysqlcppconn MysqlNativeSocket com.mysql.rdbms.mysql Socket/Pipe Path: Path to local socket or pipe file. Leave empty for default. 0 1 218 socket com.mysql.rdbms.mysql.driver.native_socket string 0 Username: root Name of the user to connect with. 0 2 218 userName com.mysql.rdbms.mysql.driver.native_socket string 1 Password: The user's password. 0 3 218 %userName%::Mysql@local com.mysql.rdbms.mysql.driver.native_socket keychain 0 Default Schema: The schema that will be used as default schema 0 4 218 getSchemata ReverseEngineeringMysql schema com.mysql.rdbms.mysql.driver.native_socket string 0 Use ANSI quotes to quote identifiers. If enabled this option overwrites the serverside settings. 1 -1 318 useAnsiQuotes com.mysql.rdbms.mysql.driver.native_socket tristate 0 Use SSL if available This option turns on SSL encryption if the client library supports it 1 -1 318 useSSL com.mysql.rdbms.mysql.driver.native boolean 0 SSL CA File: Path to Certificate Authority file for SSL. 1 -1 180 sslCA com.mysql.rdbms.mysql.driver.native string 0 SSL CERT File: Path to Certificate file for SSL. 1 -1 180 sslCert com.mysql.rdbms.mysql.driver.native string 0 SSL Key File: Path to Key file for SSL. 1 -1 180 sslKey com.mysql.rdbms.mysql.driver.native string 0 SSL Cipher: Optional list of permissible ciphers to use for SSL encryption. 1 -1 180 sslCipher com.mysql.rdbms.mysql.driver.native string 0 Standard TCP/IP over SSH MigrationGeneric QueryMysql ReverseEngineeringMysql TransformationMysql MySQL native driver using the MySQL client library http://dev.mysql.com/downloads/mysql/ libmysql.dll . 0 1 mysqlcppconn MysqlNativeSSH com.mysql.rdbms.mysql SSH Hostname: 127.0.0.1:22 SSH server hostname, with optional port number 0 1 218 sshHost com.mysql.rdbms.mysql.driver.native_sshtun string 1 SSH Username: user Name of the SSH user to connect with. 0 2 218 sshUserName com.mysql.rdbms.mysql.driver.native_sshtun string 1 SSH Password: Password for the SSH tunnel. 0 3 218 %sshUserName%::ssh@%sshHost% com.mysql.rdbms.mysql.driver.native_sshtun keychain 0 SSH Key File: Path to SSH public key file. 0 4 218 sshKeyFile com.mysql.rdbms.mysql.driver.native_sshtun file 0 MySQL Hostname: 127.0.0.1 MySQL server host relative to the SSH server 0 6 118 hostName com.mysql.rdbms.mysql.driver.native_sshtun string 1 MySQL Server Port: 3306 TCP/IP port of the MySQL server 0 7 46 port com.mysql.rdbms.mysql.driver.native_sshtun int 1 Username: root Name of the user to connect with. 0 8 218 userName com.mysql.rdbms.mysql.driver.native_sshtun string 1 Password: The MySQL user's password. 0 9 218 %userName%::Mysql@%hostName%:%port%@%sshHost% com.mysql.rdbms.mysql.driver.native_sshtun keychain 0 Default Schema: The schema that will be used as default schema 0 10 218 getSchemata ReverseEngineeringMysql schema com.mysql.rdbms.mysql.driver.native_sshtun string 0 Use compression protocol Select this option for WAN connections. 1 -1 318 CLIENT_COMPRESS com.mysql.rdbms.mysql.driver.native_sshtun boolean 0 Use ANSI quotes to quote identifiers. If enabled this option overwrites the serverside settings. 1 -1 318 useAnsiQuotes com.mysql.rdbms.mysql.driver.native_sshtun tristate 0 Use SSL if available This option turns on SSL encryption if the client library supports it 1 -1 318 useSSL com.mysql.rdbms.mysql.driver.native_sshtun boolean 0 SSL CA File: Path to Certificate Authority file for SSL. 1 -1 180 sslCA com.mysql.rdbms.mysql.driver.native string 0 SSL CERT File: Path to Certificate file for SSL. 1 -1 180 sslCert com.mysql.rdbms.mysql.driver.native string 0 SSL Key File: Path to Key file for SSL. 1 -1 180 sslKey com.mysql.rdbms.mysql.driver.native string 0 SSL Cipher: Optional list of permissible ciphers to use for SSL encryption. 1 -1 180 sslCipher com.mysql.rdbms.mysql.driver.native string 0 0 0 0 UNSIGNED ZEROFILL com.mysql.rdbms.common.typegroup.numeric TINYINT 3 0 0 2 com.mysql.rdbms.mysql 0 0 0 UNSIGNED ZEROFILL com.mysql.rdbms.common.typegroup.numeric SMALLINT 5 0 0 2 com.mysql.rdbms.mysql 0 0 0 UNSIGNED ZEROFILL com.mysql.rdbms.common.typegroup.numeric MEDIUMINT 8 0 0 2 com.mysql.rdbms.mysql 0 0 0 UNSIGNED ZEROFILL com.mysql.rdbms.common.typegroup.numeric INT 10 0 0 2 com.mysql.rdbms.mysql 0 0 0 UNSIGNED ZEROFILL com.mysql.rdbms.common.typegroup.numeric BIGINT 20 0 0 2 com.mysql.rdbms.mysql 0 0 0 UNSIGNED ZEROFILL com.mysql.rdbms.common.typegroup.numeric FLOAT 0 0 30 6 com.mysql.rdbms.mysql 0 0 0 UNSIGNED ZEROFILL com.mysql.rdbms.common.typegroup.numeric DOUBLE 0 0 30 5 com.mysql.rdbms.mysql 0 0 0 UNSIGNED ZEROFILL com.mysql.rdbms.common.typegroup.numeric DECIMAL 64 0 30 6 com.mysql.rdbms.mysql 255 0 0 BINARY UNICODE ASCII com.mysql.rdbms.common.typegroup.string CHAR 0 0 0 1 2 com.mysql.rdbms.mysql 65535 0 0 BINARY com.mysql.rdbms.common.typegroup.string VARCHAR 0 0 0 1 1 com.mysql.rdbms.mysql 0 255 0 com.mysql.rdbms.common.typegroup.blob BINARY 0 0 0 2 com.mysql.rdbms.mysql 0 65535 0 com.mysql.rdbms.common.typegroup.blob VARBINARY 0 0 0 1 com.mysql.rdbms.mysql 255 0 0 BINARY com.mysql.rdbms.common.typegroup.text TINYTEXT 0 0 0 1 0 com.mysql.rdbms.mysql 65535 0 0 BINARY com.mysql.rdbms.common.typegroup.text TEXT 0 0 0 1 2 com.mysql.rdbms.mysql -24 0 0 BINARY com.mysql.rdbms.common.typegroup.text MEDIUMTEXT 0 0 0 1 0 com.mysql.rdbms.mysql -32 0 0 BINARY com.mysql.rdbms.common.typegroup.text LONGTEXT 0 0 0 1 0 com.mysql.rdbms.mysql 0 0 0 com.mysql.rdbms.common.typegroup.blob TINYBLOB 0 0 0 0 com.mysql.rdbms.mysql 0 65535 0 com.mysql.rdbms.common.typegroup.blob BLOB 0 0 0 2 com.mysql.rdbms.mysql 0 0 0 com.mysql.rdbms.common.typegroup.blob MEDIUMBLOB 0 0 0 0 com.mysql.rdbms.mysql 0 0 0 com.mysql.rdbms.common.typegroup.blob LONGBLOB 0 0 0 0 com.mysql.rdbms.mysql 0 0 8 com.mysql.rdbms.common.typegroup.datetime DATETIME 0 0 0 1 0 com.mysql.rdbms.mysql 0 0 3 com.mysql.rdbms.common.typegroup.datetime DATE 0 0 0 1 0 com.mysql.rdbms.mysql 0 0 3 com.mysql.rdbms.common.typegroup.datetime TIME 1 0 0 0 0 com.mysql.rdbms.mysql 0 0 1 com.mysql.rdbms.common.typegroup.datetime YEAR 0 0 0 2 com.mysql.rdbms.mysql 0 0 4 com.mysql.rdbms.common.typegroup.datetime TIMESTAMP 1 0 0 0 0 com.mysql.rdbms.mysql 0 0 0 com.mysql.rdbms.common.typegroup.gis GEOMETRY 0 0 0 0 com.mysql.rdbms.mysql 0 0 0 com.mysql.rdbms.common.typegroup.gis POINT 0 0 0 0 com.mysql.rdbms.mysql 0 0 0 com.mysql.rdbms.common.typegroup.gis CURVE 0 0 0 0 com.mysql.rdbms.mysql 0 0 0 com.mysql.rdbms.common.typegroup.gis LINESTRING 0 0 0 0 com.mysql.rdbms.mysql 0 0 0 com.mysql.rdbms.common.typegroup.gis LINE 0 0 0 0 com.mysql.rdbms.mysql 0 0 0 com.mysql.rdbms.common.typegroup.gis LINEARRING 0 0 0 0 com.mysql.rdbms.mysql 0 0 0 com.mysql.rdbms.common.typegroup.gis SURFACE 0 0 0 0 com.mysql.rdbms.mysql 0 0 0 com.mysql.rdbms.common.typegroup.gis POLYGON 0 0 0 0 com.mysql.rdbms.mysql 0 0 0 com.mysql.rdbms.common.typegroup.gis GEOMETRYCOLLECTION 0 0 0 0 com.mysql.rdbms.mysql 0 0 0 com.mysql.rdbms.common.typegroup.gis MULTIPOINT 0 0 0 0 com.mysql.rdbms.mysql 0 0 0 com.mysql.rdbms.common.typegroup.gis MULTICURVE 0 0 0 0 com.mysql.rdbms.mysql 0 0 0 com.mysql.rdbms.common.typegroup.gis MULTILINESTRING 0 0 0 0 com.mysql.rdbms.mysql 0 0 0 com.mysql.rdbms.common.typegroup.gis MULTISURFACE 0 0 0 0 com.mysql.rdbms.mysql 0 0 0 com.mysql.rdbms.common.typegroup.gis MULTIPOLYGON 0 0 0 0 com.mysql.rdbms.mysql 0 0 0 com.mysql.rdbms.common.typegroup.various BIT 2 0 0 2 com.mysql.rdbms.mysql 0 0 0 com.mysql.rdbms.common.typegroup.various ENUM 0 0 0 1 10 com.mysql.rdbms.mysql 0 0 0 com.mysql.rdbms.common.typegroup.various SET 0 0 0 1 10 com.mysql.rdbms.mysql