[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 Windows

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 inst

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 tim

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 use

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 insta

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 TIMESTAM

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) depends

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 wi

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 https://lists.sourceforge.net/l

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 sour

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 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 will

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 u

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, maybe

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 appl

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: https://github.com/FirebirdSQL/firebird/blob/master/doc/sql.extensions/README.time_zone

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: |/tzdat

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 of

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 savings

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 th

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 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 .m

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

2020-04-29 Thread Alex Peshkoff via Firebird-devel
On 2020-04-28 16:55, Tony Whyman wrote: 2. There is a risk of a stealth (ICU) upgrade under Linux if the upgrade affects indexes that depend upon character set collation sequences. FYI - gfix is ready to help with this, it's enough to use switch:    -icu fix database to be u