7.1.1/OS X/Mysql export/DDL case errors for enum definitions

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.

Hi Ed, Thanks for reporting this. It will be fixed in the next maintenance release, for both ENUM and SET data types. Best Regards, Hans