[Firebird-devel] Installing the ICU Files under Windows

2020-04-28 Thread Tony Whyman
I have noticed that the FB4 snapshot builds for Windows include the icu files icudt52.dll, etc. They probably should not be installed for Windows 10 Version 1703 (Creators Update) onwards. Does the Windows installer make such a check and only install the icu files for older versions of

Re: [Firebird-devel] Installing the ICU Files under Windows

2020-04-28 Thread Adriano dos Santos Fernandes
On 28/04/2020 10:29, Tony Whyman wrote: > On 28/04/2020 14:22, Adriano dos Santos Fernandes wrote: >> I advise not to do that same thing in Windows as done in Linux, using >> the OS ICU. >> >> In Linux situation is less complex, it's a server OS. I also think it >> was an incorrect thing started

Re: [Firebird-devel] Installing the ICU Files under Windows

2020-04-28 Thread Tony Whyman
On 28/04/2020 14:47, Mark Rotteveel wrote: On 28-04-2020 15:43, Tony Whyman wrote: Apologies. I forgot to mention that I was worrying about using the ICU for the time zone database rather than character sets. Why does that worry you? Mark Because my understanding is that the ICU is the

Re: [Firebird-devel] Installing the ICU Files under Windows

2020-04-28 Thread Tony Whyman
On 28/04/2020 14:22, Adriano dos Santos Fernandes wrote: I advise not to do that same thing in Windows as done in Linux, using the OS ICU. In Linux situation is less complex, it's a server OS. I also think it was an incorrect thing started without notice by the distro people. So is the ICU

Re: [Firebird-devel] Installing the ICU Files under Windows

2020-04-28 Thread Tony Whyman
On 28/04/2020 14:22, Adriano dos Santos Fernandes wrote: Databases (indexes) depends on ICU being the same (same sort key version) or they need to be backed-up and restored (with gbak) to be fully functional. That surprises me, as I thought that a TIMESTAMP WITH TIME ZONE was stored as a GMT

Re: [Firebird-devel] Installing the ICU Files under Windows

2020-04-28 Thread Tony Whyman
Apologies. I forgot to mention that I was worrying about using the ICU for the time zone database rather than character sets. On 28/04/2020 14:39, Mark Rotteveel wrote: On 28-04-2020 15:28, Tony Whyman wrote: On 28/04/2020 14:22, Adriano dos Santos Fernandes wrote: Databases (indexes)

Re: [Firebird-devel] Installing the ICU Files under Windows

2020-04-28 Thread Adriano dos Santos Fernandes
On 28/04/2020 11:26, Tony Whyman wrote: > > > On 28/04/2020 15:11, Adriano dos Santos Fernandes wrote: >> On 28/04/2020 11:05, Tony Whyman wrote: >>> On 28/04/2020 14:59, Adriano dos Santos Fernandes wrote:

Re: [Firebird-devel] Installing the ICU Files under Windows

2020-04-28 Thread Vlad Khorsun
28.04.2020 17:26, Tony Whyman wrote: If I am wrong, it may be because the instructions are not clear. The README file says: "The content of the zip file must be extracted in the |tzdata| subdirectory of Firebird's root, overwriting the others |*.res| files of the old database. Note:

Re: [Firebird-devel] Installing the ICU Files under Windows

2020-04-28 Thread Adriano dos Santos Fernandes
On 28/04/2020 10:13, Tony Whyman wrote: > I have noticed that the FB4 snapshot builds for Windows include the > icu files icudt52.dll, etc. > > They probably should not be installed for Windows 10 Version 1703 > (Creators Update) onwards. Does the Windows installer make such a > check and only

Re: [Firebird-devel] Installing the ICU Files under Windows

2020-04-28 Thread Mark Rotteveel
On 28-04-2020 15:28, Tony Whyman wrote: On 28/04/2020 14:22, Adriano dos Santos Fernandes wrote: Databases (indexes) depends on ICU being the same (same sort key version) or they need to be backed-up and restored (with gbak) to be fully functional. That surprises me, as I thought that a

Re: [Firebird-devel] Installing the ICU Files under Windows

2020-04-28 Thread Adriano dos Santos Fernandes
On 28/04/2020 10:55, Tony Whyman wrote: > On 28/04/2020 14:47, Mark Rotteveel wrote: >> On 28-04-2020 15:43, Tony Whyman wrote: >>> Apologies. I forgot to mention that I was worrying about using the >>> ICU for the time zone database rather than character sets. >> >> Why does that worry you? >> >>

Re: [Firebird-devel] Installing the ICU Files under Windows

2020-04-28 Thread Tony Whyman
On 28/04/2020 15:11, Adriano dos Santos Fernandes wrote: On 28/04/2020 11:05, Tony Whyman wrote: On 28/04/2020 14:59, Adriano dos Santos Fernandes wrote: https://github.com/FirebirdSQL/firebird/blob/master/doc/sql.extensions/README.time_zone.md#updating-the-time-zone-database This text

Re: [Firebird-devel] New API and scrollable cursors

2020-04-28 Thread Dmitry Yemanov
28.04.2020 16:46, Mark Rotteveel wrote: On 27-04-2020 18:09, Dmitry Yemanov wrote: The remote protocol support was simply forgotten because nobody asked for that for years. Mea culpa, I was too busy with the replication stuff. Obviously, not so many people use the new API... and even less

Re: [Firebird-devel] Installing the ICU Files under Windows

2020-04-28 Thread Mark Rotteveel
On 28-04-2020 15:43, Tony Whyman wrote: Apologies. I forgot to mention that I was worrying about using the ICU for the time zone database rather than character sets. Why does that worry you? Mark -- Mark Rotteveel Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] New API and scrollable cursors

2020-04-28 Thread Mark Rotteveel
On 27-04-2020 18:09, Dmitry Yemanov wrote: The remote protocol support was simply forgotten because nobody asked for that for years. Mea culpa, I was too busy with the replication stuff. Obviously, not so many people use the new API... and even less people use new features introduced there.

Re: [Firebird-devel] Installing the ICU Files under Windows

2020-04-28 Thread Mark Rotteveel
On 28-04-2020 16:05, Tony Whyman wrote: On 28/04/2020 14:59, Adriano dos Santos Fernandes wrote: https://github.com/FirebirdSQL/firebird/blob/master/doc/sql.extensions/README.time_zone.md#updating-the-time-zone-database This text applies to building firebird. I am worrying about the end

Re: [Firebird-devel] Installing the ICU Files under Windows

2020-04-28 Thread Adriano dos Santos Fernandes
On 28/04/2020 11:05, Tony Whyman wrote: > > On 28/04/2020 14:59, Adriano dos Santos Fernandes wrote: >> >> https://github.com/FirebirdSQL/firebird/blob/master/doc/sql.extensions/README.time_zone.md#updating-the-time-zone-database >> >> > This text applies to building firebird. You are wrong,

Re: [Firebird-devel] Installing the ICU Files under Windows

2020-04-28 Thread Vlad Khorsun
28.04.2020 16:13, Tony Whyman wrote: I have noticed that the FB4 snapshot builds for Windows include the icu files icudt52.dll, etc. ICU52 included into FB3. FB4 includes ICU63. They probably should not be installed for Windows 10 Version 1703 (Creators Update) onwards. Does the Windows

Re: [Firebird-devel] New API and scrollable cursors

2020-04-28 Thread Mark Rotteveel
On 27-04-2020 19:53, Pavel Cisar wrote: I don't know if it's possible to provide such feature (even with embedded-only) in wire-protocol-based connectivity packages like JayBird or .NET Provider, but I guess if it would be doable, their maintainers would eventually implement it. In Jaybird

Re: [Firebird-devel] Installing the ICU Files under Windows

2020-04-28 Thread Kjell Rilbe
Den 2020-04-28 kl. 15:59, skrev Adriano dos Santos Fernandes: On 28/04/2020 10:55, Tony Whyman wrote: Because my understanding is that the ICU is the source of the time zone database and will have to be updated every time a time zone changes or there are changes to the dates for daylight

Re: [Firebird-devel] Installing the ICU Files under Windows

2020-04-28 Thread Tony Whyman
On 28/04/2020 14:59, Adriano dos Santos Fernandes wrote: https://github.com/FirebirdSQL/firebird/blob/master/doc/sql.extensions/README.time_zone.md#updating-the-time-zone-database This text applies to building firebird. I am worrying about the end user's strategy. My point is that there

Re: [Firebird-devel] Installing the ICU Files under Windows

2020-04-28 Thread Tony Whyman
So, I guess this has been added since beta 1. I can see it in the latest Windows snapshot, but not in the latest Linux snapshot. So the README should make clear that the tzdata directory only applies to the Windows builds? Back to my original concern. While the README file gives an outline

Re: [Firebird-devel] Installing the ICU Files under Windows

2020-04-28 Thread Adriano dos Santos Fernandes
On 28/04/2020 11:40, Vlad Khorsun wrote: > > Linux snapshot builds contains nor ICU It's ok. > , nor tzdata. It's not ok. Adriano Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Installing the ICU Files under Windows

2020-04-28 Thread Lester Caine
On 28/04/2020 15:10, Kjell Rilbe wrote: https://github.com/FirebirdSQL/firebird/blob/master/doc/sql.extensions/README.time_zone.md#updating-the-time-zone-database As a Firebird user I would suggest that this article/info is clearly stated in every version of Firebird release notes, and also

[Firebird-devel] ODP: New API and scrollable cursors

2020-04-28 Thread Karol Bieniaszewski
May i ask if this is big developmenet cost to support it on the client side api? Maybe it is shorter time than this disscussion  I try make this discussion lighter  Regards, Karol Bieniaszewski Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] ODP: New API and scrollable cursors

2020-04-28 Thread Dmitry Yemanov
29.04.2020 00:36, Karol Bieniaszewski пишет: May i ask if this is big developmenet cost to support it on the client side api? It's supported in the API, but not supported in the remote protocol. IIRC, it can be easily implemented if a scrollable cursor would disable client-side asynchronous

Re: [Firebird-devel] Installing the ICU Files under Windows

2020-04-28 Thread Paul Reeves
On Tue, 28 Apr 2020 14:13:20 +0100 Tony Whyman wrote: > One reason that I could not check this is that I couldn't find any Windows > Installer source files in the source code distribution. Does Firebird use > Open Source  WIX XML files for the installer or some proprietary tool to > create the