Supported MySQL Versions
5.5, 5.6, 5.7, and 8.0
Encoding Support
MySQL encoding is automatically detected by default, but manual setting is also supported. The manual setting only supports the following list of Java-style encoding names.
| MySQL Encoding Name | Java-style Encoding Name |
|---|---|
| ascii | US-ASCII |
| big5 | Big5 |
| gbk | GBK |
| sjis | SJIS (or Cp932 or MS932 for MySQL < 4.1.11) |
| cp932 | Cp932 or MS932 (MySQL > 4.1.11) |
| gb2312 | EUC_CN |
| ujis | EUC_JP |
| euckr | EUC_KR |
| latin1 | Cp1252 |
| latin2 | ISO8859_2 |
| greek | ISO8859_7 |
| hebrew | ISO8859_8 |
| cp866 | Cp866 |
| tis620 | TIS620 |
| cp1250 | Cp1250 |
| cp1251 | Cp1251 |
| cp1257 | Cp1257 |
| macroman | MacRoman |
| macce | MacCentralEurope |
| utf8 | UTF-8 |
| ucs2 | UnicodeBig |
Connection Preview Support
Supports ordinary tables and views that can be listed by the SHOW TABLES command.
SQL Query Dataset Support for SQL
Only SELECT statements are supported, including all SELECT-related features supported by the connected MySQL. Users need to ensure the syntax complies with MySQL standards.
MySQL Authentication Method Support
Supports username and password authentication methods. SSL, PAM, and other authentication methods are not supported.
Unsupported Field Types
The following types of columns in MySQL tables cannot be processed correctly. If other fields from this table are needed, you can input a SELECT statement in the SQL query that excludes this field.
- TIME
- JSON
- GEOMETRY
- POINT
- LINESTRING
- POLYGON
- MULTIPOINT
- MULTILINESTRING
- MULTIPOLYGON
- GEOMETRYCOLLECTION