Re: [Firebird-docs] LangRef 2.5beta1 - a few suggestions /2
Aage Johansen wrote: > First, thanks to Paul for checking my suggestions. > Actually, I may have misremembered: I thought there might be pitfalls > regarding the sign of the result. There are. Or rather, there is one: 0x8000 - 0x map to negative INTEGER values, whereas 0x08000 - 0x0 map to positive BIGINTs. But I see Helen has taken care of that in her latest commit. > As for BETWEEN and the others: maybe precedence is totally irrelevant > for "comparison predicates". I just mentioned it since "comparison > operators" have defined precedence. According to IBPhoenix's Using Firebird and Helen's Firebird Book, BETWEEN...AND, LIKE, CONTAINING and STARTING [WITH] all have precedence 9 (lowest) among the comparison operators. I assume that the same is true for SIMILAR TO. > I've spent most of Easter in hospital, and haven't really been keen on > doing testing. Sorry about that. Hope you're doing alright now! Cheers, Paul Vinkenoog -- Transform Data into Opportunity. Accelerate data analysis in your applications with Intel Data Analytics Acceleration Library. Click to learn more. http://pubads.g.doubleclick.net/gampad/clk?id=278785471=/4140 ___ Firebird-docs mailing list Firebird-docs@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-docs
Re: [Firebird-docs] LangRef 2.5beta1 - a few suggestions /2
Hi Helen, > Another thing we seem to have missed by the same method (!) was binary > strings in hex format. > > Unless you have feelings against it, I should just pick up the > relevant source from LangUpdate25, slot it into the appropriate > places and cross-ref where needed. Yes, please use whatever you can use. The hex numeral stuff is under langrefupd25-hexnumerals and (BIGINT-specific) langrefupd25-bigint; the 'binary' strings are at langrefupd25-hexbinstrings. Cheers, Paul -- Transform Data into Opportunity. Accelerate data analysis in your applications with Intel Data Analytics Acceleration Library. Click to learn more. http://pubads.g.doubleclick.net/gampad/clk?id=278785351=/4140 ___ Firebird-docs mailing list Firebird-docs@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-docs
Re: [Firebird-docs] LangRef 2.5beta1 - a few suggestions /2
Hi Helen, > > p.51 (end of first paragraph): > > A CONTAINING search is not case-sensitive. > > > Maybe a comment/warning on accent-sensitivity? > > I think you might be the first person involved with this text who has > day-to-day experience with data in a language with accented > characters. What is there to say? Two short tests using iso8859_1 and utf8 reveal that CONTAINING is accent-sensitive, i.e. 'ABCDEFG' containing 'DÉF' is false, *unless* an accent-insensitive collation is used. I assume it's the same with other character sets. Cheers, Paul -- Transform Data into Opportunity. Accelerate data analysis in your applications with Intel Data Analytics Acceleration Library. Click to learn more. http://pubads.g.doubleclick.net/gampad/clk?id=278785351=/4140 ___ Firebird-docs mailing list Firebird-docs@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-docs