Official Content

Sets the MySQL version range for which the code is generated.

Values

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.

Scope

Available at the Data Store.
Data Store: MySQL
Generators: .NET, .NET Framework, Java

Description

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

Runtime/Design time

This property applies only at design time.

How to apply changes

To apply the corresponding changes when the property value is configured, execute a Rebuild All.

See Also

PostgreSQL version property
SQL server version property
Oracle version property
DB2 UDB Version property
Informix Version property

Last update: November 2024 | © GeneXus. All rights reserved. GeneXus Powered by Globant