Subject Re: [Firebird-Java] numeric(15,2) and number of decimal places
Author Roman Rokytskyy
> Thank you Helen for the information. We did a backup on the Interbase
> 5.6 and then restored the gbk to an fdb file on the Firebird server.
> The ODS version is 10.1. How do we set the Dialect level in the
> client? I thought this was a database level thing and did not realize
> that the Jaybird client needed to be set to Dialect 1 as well...

If you wish to connect in dialect 1, you have to specify connection
property (sqlDialect=1):

http://jaybirdwiki.firebirdsql.org/jaybird/doku.php?id=config:driver_config
http://jaybirdwiki.firebirdsql.org/jaybird/doku.php?id=config:connection_properties

By default client dialect is 3.

Roman