Re: [Firebird-devel] blr 31 & 30

2021-02-04 Thread Alex Peshkoff via Firebird-devel
On 2/4/21 7:29 PM, Mark Rotteveel wrote: On 2021-02-04 15:55, Norbert Saint Georges wrote: Mark Rotteveel a écrit : On 2021-02-04 09:39, Norbert Saint Georges wrote: yes, this is what I found but there is no definition RDB $ FIELD_TYPE = 30 or 31 in rdb $ types in FB4, what is it for? The EX

Re: [Firebird-devel] blr 31 & 30

2021-02-04 Thread Mark Rotteveel
On 2021-02-04 15:55, Norbert Saint Georges wrote: Mark Rotteveel a écrit : On 2021-02-04 09:39, Norbert Saint Georges wrote: yes, this is what I found but there is no definition RDB $ FIELD_TYPE = 30 or 31 in rdb $ types in FB4, what is it for? The EXTENDED TIMESTAMP WITH TIME ZONE and EXTEND

Re: [Firebird-devel] blr 31 & 30

2021-02-04 Thread Norbert Saint Georges
Mark Rotteveel a écrit : On 2021-02-04 09:39, Norbert Saint Georges wrote: yes, this is what I found but there is no definition RDB $ FIELD_TYPE = 30 or 31 in rdb $ types in FB4, what is it for? The EXTENDED TIMESTAMP WITH TIME ZONE and EXTENDED TIME WITH TIME ZONE are protocol-only data-type

Re: [Firebird-devel] blr 31 & 30

2021-02-04 Thread Mark Rotteveel
On 2021-02-04 09:39, Norbert Saint Georges wrote: yes, this is what I found but there is no definition RDB $ FIELD_TYPE = 30 or 31 in rdb $ types in FB4, what is it for? The EXTENDED TIMESTAMP WITH TIME ZONE and EXTENDED TIME WITH TIME ZONE are protocol-only data-types, where it will always in

Re: [Firebird-devel] blr 31 & 30

2021-02-04 Thread Norbert Saint Georges
Jirí Cincura a écrit : yes, this is what I found but there is no definition RDB $ FIELD_TYPE = 30 or 31 in rdb $ types in FB4, what is it for? The "extended" definition is just for protocol, where the message contains also the TZ offset. But this is never stored. OK, thanks -- Norbert Saint

Re: [Firebird-devel] blr 31 & 30

2021-02-04 Thread Jiří Činčura
> yes, this is what I found but there is no definition RDB $ FIELD_TYPE = > 30 or 31 in rdb $ types in FB4, what is it for? The "extended" definition is just for protocol, where the message contains also the TZ offset. But this is never stored. -- Mgr. Jiří Činčura https://www.tabsoverspaces.c

Re: [Firebird-devel] blr 31 & 30

2021-02-04 Thread Norbert Saint Georges
Jirí Cincura a écrit : In Firebird 4. For example here https://github.com/FirebirdSQL/firebird/blob/T4_0_0_RC1/src/include/firebird/impl/sqlda_pub.h#L81. -- Mgr. Jirí Cincura https://www.tabsoverspaces.com/ yes, this is what I found but there is no definition RDB $ FIELD_TYPE = 30 or 31 in r

Re: [Firebird-devel] blr 31 & 30

2021-02-04 Thread Jiří Činčura
In Firebird 4. For example here https://github.com/FirebirdSQL/firebird/blob/T4_0_0_RC1/src/include/firebird/impl/sqlda_pub.h#L81. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ On Thu, Feb 4, 2021, at 09:26, Norbert Saint Georges wrote: > Hi, > In the NETProvider v8.0 code I can read the

[Firebird-devel] blr 31 & 30

2021-02-04 Thread Norbert Saint Georges
Hi, In the NETProvider v8.0 code I can read the definition of the TimeStampTZEx and TimeTZEx fields having the values blr respectively 31 & 30 and data type respectively 32748 & 32750 as I cannot find these values anywhere else, is it expected, in a future version of Firebird, an overload of ti