-
Type: Improvement
-
Status: Resolved
-
Priority: Minor
-
Resolution: Applied
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: Domain Model
-
Labels:None
-
Proposal:
-
Resolution:
Clarification needed on the use of quotes in a CONTAINS() query to search on phrases.
Spec:
2575 BNF grammar structure:: CONTAINS ( [ <qualifier> ,] ' <text search expression> ' )
2413 <phrase> ::= <quote> <word> [
{<space> <word>} ... ] <quote>
2422 <quote> ::= "'" !! Single-quote only, consistent with SQL-92 string literal
2597 Within a word or phrase, each (single-)quote must also be escaped by a preceding backslash "\"
The spec specifically states that <quote> is single-quote only.
My questions is on specifying a phrase inside the CONTAINS().
Since the entire text search expression is enclosed in single quotes,
I question whether a phrase should again be enclosed in single quotes, or should it be in double-quotes.
According to spec:
Word search: CONTAINS('house')
Phrase search : CONTAINS(' 'my house' ')
Should phrases be in double-quotes? ==> CONTAINS(' "my house" ')