Sets the MySQL version range for which the code is generated.
|4.x to 5.0.2 ||The MySQL version installed on the Server is between 4.x and 5.0.2.|
|5.0.3 to 5.7.6 ||The MySQL version installed on the Server is between 5.0.3 and 5.7.6.|
|5.7.7 to 5.7.23 ||The MySQL version installed on the Server is between 5.7.7 and 5.7.29.|
|8.x or higher ||The MySQL version installed on the Server is 8.x or higher.|
Available at the Data Store.
Data Store: MySQL
Generators: .NET, .NET Framework, Java
This property is used, for example, to determine the syntax for OUTER JOINs and for table creation/reorganization (i.e. syntax of CREATE TABLE, CREATE INDEX, etc.).
Notes related to MySQL 8 or higher:
- Java-specific: If date fields are read with one less day (e.g.: 1930-01-30 is returned as 1930-01-29), you may need to add the timezone of the application server to the connection string (eg.:&serverTimezone=America/Montevideo)
- As stated in the Release Notes of MySQL 8, the default character_set_server, character_set_database, collation_server, and collation_database environment variables changed. In addition, "The pad attribute for Unicode 9.0.0 collations was changed from PAD SPACE to NO PAD." Consequently, spaces are treated at the end of strings like any other character, which means that comparing "A " with "A" does not return true by default. If you don't want this behavior, you should change those default values.
- .NET-specific: SAC 43792 - MySQL 8.0 support in .NET
This property applies only at design time.
To apply the corresponding changes when the property value is configured, execute a Rebuild All.
PostgreSQL version property
SQL server version property
Oracle version property
DB2 UDB Version property
Informix Version property