Bet I know the answer to this, but there's no magi...
# cfml-generald
Dave Merrill
05/19/2023, 7:18 PMBet I know the answer to this, but there's no magic flag/QoQ setting to make QoQ NOT case sensitive, is there?
State of the art is WHERE UPPER(sqlValue) = uCase(valueToSearchFor)?
b
bdw429s
05/19/2023, 7:23 PM@Dave Merrill Correct. You have to use upper or lower
š 1
bdw429s
05/19/2023, 7:24 PMI considered when I was revamping the Lucee QoQ to either
ā¢ make text compare case insensitive by default
ā¢ add a flag
but I was concerned about the performance of potentially many thousands of
String.toUpperCase()bdw429s
05/19/2023, 7:25 PMPlus, Adobe CF is case sensitive so anything Lucee did differently would be a potentially breaking difference
ā
1
t
Tim
05/19/2023, 7:36 PMI was unaware that this was a thing... That's so weird, because generally, neither CF nor SQL are case-sensitive.
b
bdw429s
05/19/2023, 7:38 PMYeah, it always puzzled me why QoQ did this from the get-go. My guess was either performance or an oversight š
m
Myka Forrest
05/19/2023, 9:08 PMI've run into many strange issues due to QoQ case-sensitivity, especially if the case is different between select clause and order by clause.
b
bdw429s
05/19/2023, 9:15 PMIn Lucee, or Adobe CF?
a
Adam Cameron
05/19/2023, 9:40 PM
If I was to guess at the reason for the case sensitivity... QoQ was added in CFMX6... which was written by Java devs. And Java is... case sensitive. Probably didn't occur to anyone doing the dev work that CFML isn't case-sensitive by default. The 6 dev cycle was a bit of a shambles (it wasn't really usable until 6.1; it was kinda usable after 6.0's third update), so would not surprise me if the testing of new stuff was very thorough.
ā¤ļø 1
4 Views