> As far as I understand it, Dialect governs the SQL you can use,
> as well as
> the data types - bigint, for example, is only available under
> Dialect 3. I
> haven't played with cache size at all.
>
> Regards
>
> Tim

Dialect has nothing to do with what SQL you can use - it's all standard SQL
no matter what dialect the db is set at.
Alan