I’m evaluating TDM 22.214.171.124.
I’m really disapppointed by the DDL script generation for MySQL.
There was the PrimaryKey/Auto_increment bug… already fixed.
Then the global before/after script doesn’t work, so I’ve done that in the script to correct it :
if (Instance.Model.BeforeScript != “”)
text += Instance.Model.BeforeScript+"\r\n";
if (Instance.Model.AfterScript != “”)
text += “\r\n\r\n”+Instance.Model.AfterScript;
Then I wonder why column comment are on a different line ?
But the most annoying problem is the script encoding !!!
I just cannot run it via the mysql command line…
Here’s the error :
mysql> source base.sql
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right synta
x to use near ’ ■/
Opening the file with an hexa editor show me some funny things :
- the script starts with 2 non-existing characters
- every character is coded on 2 bytes ! And I don’t know witch encoding can do that… certainly not UTF8…
(I’m using a French Windows XP Pro)