I have run into the same problem, but I have found it's worth the effort to
maintain both dialects in a continuing effort to eventually move all my
customers to dialect 3. There are a couple of real gotchas with d3 but the
big int is worth the trouble for me.
Kind Regards,
Kevin

-----Original Message-----
From: Nico Callewaert [mailto:ncw@...]
Sent: Wednesday, June 02, 2004 6:18 AM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Re: Dialect 3 to dialect 1 ?


Hi Martijn,

That's correct, but the problem is, we maintain 1 updatescript for
all customers. So, if we use TIMESTAMP in the script, it won't work
for IB customers, and if we use DATE then the TIME part of the data
is gone in FB. That's our main problem for now :-)

Thanks ! Nico


--- In firebird-support@yahoogroups.com, "Martijn Tonies"
<m.tonies@u...> wrote:

> Hi Nico,
>
> > Thanks for the response. Are you sure about Timestamp in IB 5.6,
> > dialect 1 ? Because most of our customers are running under

dialect

> > 1 still.
>
> In IB < 6, it's called DATE, in IB 6, dialect 3, it's called

TIMESTAMP.

>
> In dialect 3, DATE holds date only while TIME holds time only.
> TIMESTAMP holds both.
>
> With regards,
>
> Martijn Tonies
> Database Workbench - developer tool for InterBase, Firebird, MySQL

& MS SQL

> Server.
> Upscene Productions
> http://www.upscene.com
>
>
> > Best regards, Nico
> >
> >
> > --- In firebird-support@yahoogroups.com, "Martijn Tonies"
> > <m.tonies@u...> wrote:
> > > 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
> >
> >
> >
> >
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
> >

Yahoo! Groups Sponsor
ADVERTISEMENT





----------------------------------------------------------------------------
--
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

b.. To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]