[Firebird-docs] [] Firebird 2.5 Language Reference Beta 1
In {firebird-devel] liviusliviuswrote: Hi, i do not know if this is good place to but: on page 49 is: "If you need to do a case-insensitive search for something enclosed inside a string ( LIKE '%Abc%' ), use of the CONTAINING predicate is recommended, in preference to the LIKE predicate." and on page 50 is: "A CONTAINING search is case-sensitive" i am confused by "case-insensitive" and "case-sensitive" here regards, Karol Bieniaszewski Good catch - should be "is NOT case-sensitive" Helen -- Site24x7 APM Insight: Get Deep Visibility into Application Performance APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month Monitor end-to-end web transactions and take corrective actions now Troubleshoot faster and improve end-user experience. Signup Now! http://pubads.g.doubleclick.net/gampad/clk?id=267308311=/4140 ___ Firebird-docs mailing list Firebird-docs@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-docs
Re: [Firebird-docs] Langref - Expressions/Constant
Title: Re: [Firebird-docs] Langref - Expressions/Constant Hello , Monday, February 1, 2016, 8:25:55 PM, Michał Ziemski wrote: Hi! I've been going through the beta langref. In fblangref25-commons-expressions there is a description for "Constant": "A number; or a string literal enclosed in apostrophes" This should also include string literat with encoding provided, like: _utf8 'abc123' or _win1250 'abc123' The "introducer syntax" for forcing the character set of string literals is actually discussed in the DML chapter, under the INSERT statement. However, I agree with you, it should be in the "Common Elements", since it is not restricted to INSERT statements. Other discussions should link to that. It would be also helpful to expand somewhat on constant number format that - dot is the decimal spearator - exponential notation is supproted (like 2.3e-5) Amazingly, so far everyone except you has overlooked that exponential notation for numeric constants is valid but missing. And yes, I agree it is worth including a note that the "dot" character is the only valid decimal separator in SQL...and probably also that thousands separators (be they comma, dot or space) are not valid at all. Some more good catches! Cheers, Helen -- Site24x7 APM Insight: Get Deep Visibility into Application Performance APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month Monitor end-to-end web transactions and take corrective actions now Troubleshoot faster and improve end-user experience. Signup Now! http://pubads.g.doubleclick.net/gampad/clk?id=267308311=/4140___ Firebird-docs mailing list Firebird-docs@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-docs
Re: [Firebird-docs] Langref - Expressions/Constant
Hi! > > Hi! > > I've been going through the beta langref. > In fblangref25-commons-expressions there is a description for "Constant": > "A number; or a string literal enclosed in apostrophes" > > This should also include string literat with encoding provided, like: > _utf8 'abc123' or _win1250 'abc123' > > The "introducer syntax" for forcing the character set of string literals > is > actually discussed in the DML chapter, under the INSERT statement. > However, I agree with you, it should be in the "Common Elements", since it > is not restricted to INSERT statements. Other discussions should link to > that. > A few more ideas to clarify string constants: - abyility to include an apostrophe in sring by using 2 apostrophes: 'john''s car' - I'd stress thet only an apostrophe is allowed and double quotest serve other purpose - this is isn't always the case in other DBs (MS Access for example) and I remember having problem with it myself when I was yet new to FB. Column name expression: - Firebird converts table/column names to upper case internally. I think this should be explicitly stated as it's, I believe, failrly unique to firebird - double quotes can be used to make the field case sensitive and allow for some wild characters inside the symbol (spaces, parentheses and so on) - it'd be convenient to state which characters are allowed in a symbol name and which are allowed in a quoted symbol name Cheers! Michał -- Site24x7 APM Insight: Get Deep Visibility into Application Performance APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month Monitor end-to-end web transactions and take corrective actions now Troubleshoot faster and improve end-user experience. Signup Now! http://pubads.g.doubleclick.net/gampad/clk?id=267308311=/4140___ Firebird-docs mailing list Firebird-docs@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-docs