On 13/10/2017 13:28, Magnus Johansson wrote: > -----Original Message----- > From: Adriano dos Santos Fernandes [mailto:adrian...@gmail.com] > Sent: Friday, October 13, 2017 6:11 PM > To: firebird-devel@lists.sourceforge.net > Subject: Re: [Firebird-devel] FB 3.0 Replacing ICU libraries on Windows > > On 12/10/2017 13:49, Vlad Khorsun via Firebird-devel wrote: >> 12.09.2017 15:33, Adriano dos Santos Fernandes wrote: >>> On 12/09/2017 08:46, Magnus Johansson wrote: >> ... >>>> SELECT FIELD_UTF_SV_CI_NUM >>>> FROM TABLE_T >>>> WHERE FIELD_UTF_SV_CI_NUM BETWEEN '' AND 'b' >>>> ORDER BY 1; >>>> FIELD_UTF_SV_CI_NUM >>>> =================== >>>> 1 >>>> 2 >>>> 10 >>>> 20 >>>> a >>>> A >>>> aa >>>> Aa >>>> AA >>>> b >>>> =================== >>>> Not the expected result. >>>> Where did the 'B' go? >>> This should be verified. >> Adriano, did you investigate it ? May i help somehow ? >> > SQL> SELECT FIELD_UTF_SV_CI_NUM > CON> FROM TABLE_T > CON> WHERE FIELD_UTF_SV_CI_NUM BETWEEN '' AND 'b' > CON> ORDER BY 1; > > FIELD_UTF_SV_CI_NUM > ==================== > 1 > 2 > 10 > 20 > a > A > aa > Aa > AA > b > B > > So what is the problem? > > Adriano, is that with or without index? > > Ah, sorry, this is the problem and I now see it again.
I can check it in some days. Please add it to the tracker. Adriano ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel