About SQL ISO Standards

As mentioned in the previous section, Hyperstage uses the same syntax as the standard MySQL commands. For information about the compliance of the MySQL language with ISO SQL standards, see MySQL Standards Compliance in the MySQL 5.x Reference Manual.

Hyperstage is approaching full ISO SQL compliance. However, certain sections of the ISO SQL standard are open to interpretation and each DBMS, including Hyperstage, may implement these sections slightly differently. Consequently, Hyperstage query results may differ from those of other databases.

For example, the SQL standard does not define a default collation for string comparisons, which affects the ordering of query results.


WebFOCUS