[firebird-support] Switch back from Firebird 3.0.X to 2.5.X

2017-06-29 Thread dam...@wxs.nl [firebird-support]
Because of the new behaviour of Firebird 3.0.X regarding explicit nested inner joins (where in the "on" part, a reference to a table column on a higher level in the hierarchy is not allowed anymore), I want to switch back to Firebird 2.5.x. I made a transportable backup from the 3.0 database, bu

[firebird-support] Re: Switch back from Firebird 3.0.X to 2.5.X

2017-06-29 Thread dam...@wxs.nl [firebird-support]
Resolved: You have to backup and restore the 3.0 database with the 2.5 gbak.

Re: [firebird-support] Changing collation

2017-06-29 Thread Tomasz Tyrakowski t.tyrakow...@sol-system.pl [firebird-support]
On 28.06.2017 at 22:58, Ann Harrison aharri...@ibphoenix.com [firebird-support] wrote: > Not if you have indexes, a declared primary key, or a declared unique > constraint. The index keys are a transformation of the value into a format > that produces the desired ordering through binary compariso

Re: [firebird-support] Changing collation

2017-06-29 Thread Tomasz Tyrakowski t.tyrakow...@sol-system.pl [firebird-support]
On 29.06.2017 at 19:15, Tomasz Tyrakowski t.tyrakow...@sol-system.pl [firebird-support] wrote: > On 28.06.2017 at 22:58, Ann Harrison aharri...@ibphoenix.com > [firebird-support] wrote: > [...] > Or is 3 strictly bound > to PXW_PLK and always means PXW_PLK, regardless of the character set of > the