Re: Enhydra: Interbase 64 bit Problem

[Bill Karwin <bill.karwin@xxxxxxxxxx>]

Marc Spitzer wrote:
> 
> Interbase 6 has 2 dialects for production use, 1 & 3.   dialect 1 is for
> backward compatibility and does have the new v6 features, 64 bit ints for
> example.  Check to see if your database is created a dialect 1 database, if
> it is you do not have 64 bit ints, or it could be your jdbc driver is
> dialect 1(is that possible???).  If you want the new features of v6 create
> the db as dialect 3.

InterBase's JDBC driver _only_ supports dialect 1.  They haven't updated
it to support the new datatypes in InterBase 6.  There's no word on when
(or if) they will do this.

You can access a dialect 3 database with a dialect 1 client as long as
your queries don't reference any of the specific columns that use
dialect 3 dependant datatypes.

InterBase's dialect 3 features are:  
- the 64-bit exact NUMERIC datatype
- SQL-compliant TIMESTAMP, DATE, and TIME datatypes
- delimited identifiers 
  (e.g. SELECT "Key" FROM "My Table").

-- 
Bill Karwin (bill@xxxxxxxxxx)
Application Architect - Lutris Technologies Inc.
-----------------------------------------------------------------------------
To unsubscribe from this mailing list, send email to majordomo@xxxxxxxxxxx
with the text "unsubscribe enhydra" in the body of the email.
If you have other questions regarding this mailing list, send email to
the list admin at owner-enhydra@xxxxxxxxxxxx