> Unfortunately, I believe that both the CHARSET and ENGINE keywords are > MySQL specific.
Oh, that's no kind of blanket impediment to adding them to Mayfly. In fact, they were already there in CREATE TABLE (although it looks like they didn't make it to the documentation). At least for now, they don't try to approximate MySQL semantics, but are just ignored. I've added the same thing for ALTER TABLE and ALTER SCHEMA (see the Mayfly documentation - I didn't try to implement all the syntaxes which MySQL documents, much less the larger set of syntaxes which MySQL seems to accept). As for the collation, that would be a new feature. I'm a bit reluctant to let people specify a collation and not actually collate (sort, compare) according to that. Are you really needing to specify a non-default collation? ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
