Subject Re: [firebird-support] Dialect 3 to dialect 1 ?
Author Martijn Tonies
Hi Nico,

> After migrating from IB 5.6 to FB 1.5, we changed the dialect to 3.
> Because there is no common datatype in IB and FB to hold Date and
> Time in 1 field,

Yes there is - its called TIMESTAMP.

>we want to switch back to dialect 1, so we can use
> DATE datatype again. Is this possible, because after changing with
> GFIX, we get BIGINT errors.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com