Re: [Firebird-devel] Describing server types on client side

2019-09-17 Thread Mark Rotteveel
On 16-9-2019 13:05, Dimitry Sibiryakov wrote: 16.09.2019 12:50, Alex Peshkoff via Firebird-devel wrote: It was very good (but left unnoticed suggestion) from Dimitry Sibiryakov: add single SQL statement to tune automatic datatypes coercion. I agree with this suggestion and suggest to drop all '

Re: [Firebird-devel] Describing server types on client side

2019-09-17 Thread Mark Rotteveel
On 16-9-2019 12:50, Alex Peshkoff via Firebird-devel wrote: In FB4 there was added a number of new datatypes (and will be added 128-bit integers). For all of them separate SET statement is added to make it possible to bind them with some old, well known to old clients datatype. Also DPB item is

Re: [Firebird-devel] Describing server types on client side

2019-09-16 Thread Alex Peshkoff via Firebird-devel
On 16.09.2019 14:05, Dimitry Sibiryakov wrote: 16.09.2019 12:50, Alex Peshkoff via Firebird-devel wrote: It was very good (but left unnoticed suggestion) from Dimitry Sibiryakov: add single SQL statement to tune automatic datatypes coercion. I agree with this suggestion and suggest to drop all

Re: [Firebird-devel] Describing server types on client side

2019-09-16 Thread Dimitry Sibiryakov
16.09.2019 12:50, Alex Peshkoff via Firebird-devel wrote: It was very good (but left unnoticed suggestion) from Dimitry Sibiryakov: add single SQL statement to tune automatic datatypes coercion. I agree with this suggestion and suggest to drop all 'set bind' statements, all related DPB items and

Re: [Firebird-devel] Describing server types on client side

2019-09-16 Thread Alex Peshkoff via Firebird-devel
On 16.09.2019 13:50, Alex Peshkoff via Firebird-devel wrote:     Example -  after ALTER SESSION DESCRIBE DECFLOAT AS CHAR char() wll be used for decfloat(16) and char() for decfloat(34). Sorry for missed numbers: ALTER SESSION DESCRIBE DECFLOAT AS CHAR char(23) wll be used for decfloat(16) an

[Firebird-devel] Describing server types on client side

2019-09-16 Thread Alex Peshkoff via Firebird-devel
In FB4 there was added a number of new datatypes (and will be added 128-bit integers). For all of them separate SET statement is added to make it possible to bind them with some old, well known to old clients datatype. Also DPB item is added to control initial state of this feature. It was ver