...
The following versions are supported:
- MySQL 8.4
- MySQL 8.0
- MySQL 5.7 (deprecated)
If data continuously loads in an explorer view, increase the value of the read_rnd_buffer_size variable.
...
To perform database updates after upgrading DTP, MySQL must have sufficient disk space to write temporary files, which may be an issue for larger databases. When modifying tables or adding an index during an update, MySQL writes to temporary storage (the directory specified by the MySQL tmpdir variable, which on Linux is the /tmp directory by default). This temporary storage may be on a different disk partition than where it stores its database tables. For more information on how to configure where MySQL stores temporary files, see: https://dev.mysql.com/doc/refman/8.0/en/temporary-files.html.
MySQL
...
Character Set and Collation Settings
The MySQL creation script for the DTP database uses the character set utf8 utf8mb4 and collation utf8utf8mb4_general_ci so that UTF-8 characters (for example, Japanese or Chinese) can be stored in the database. DTP does not support UTF-8 4-byte character encoding ("utf8mb4").
The MySQL server character set and collation must also be set to UTF-8 to save UTF-8 characters in the database. We highly recommend that the MySQL server changes are made prior to creating the database:
- Locate the my.ini (Windows) or my.cnf (Linux) file and open it in an editor.
- In the section under [mysqld], add/edit the following properties:
character-set-server = utf8
collation-server = utf8_general_ci
.
| Note | ||
|---|---|---|
| ||
Older versions of DTP created databases using the |
If you need to use different settings, you can create the database and database user yourself and then populate the database using DTP. See Create a DTP Schema for an Existing Database for more information about populating the database using DTP.
See the MySQL documentation for more information about server character set configuration and creating MySQL databases:
...
...
...
...
Oracle
The following versions are supported:
- 23c
- 19c
- 18c (deprecated)
Oracle
...
Character Set and Collation Settings
Oracle recommends setting the target character set to AL32UTF8. See the Oracle Database Migration Assistant for Unicode documentation for instructions: https://docs.oracle.com/database/121/DUMAG/ch2migrasteps.htm#DUMAG136.
...