7.1.1/OS X/Mysql export/DDL case errors for enum definitions
started a topic
about 10 years ago
[This topic is migrated from our old forums. The original author name has been removed]
I was experimenting with the export database feature on a mysql database.
I noticed that enum values which were originally defined as multiword initial uppercase strings e.g. ( +My Title+ ) had exported definitions as all uppercase ( +MY TITLE+ ) even though the value used for the insert has the correct (mixed) case. The same definition discrepancy exists between the DDL and Native DDL tabs for the table.
I know that mysql uses case insensitive string comparison but the intent behind the export was to transfer the data to Postgresql when case does matter and this discrepancy becomes a serious issue requiring the enum definition to be hand edited.
Thus for export purposes Native DDL is correct and both DDL and export database are wrong.