- Daniel Vivier
- PowerBuilder
- Saturday, 11 May 2019 01:17 AM UTC
I did a filter on some names, some of which started with "A" or other capital letters, and some of which started with "a", where the filter expression was:
'a'
It selected all of those names. If that was case sensitive, like I thought DW expression comparisons on strings were supposed to be, it would have excluded all of the ones that started with capital letters, since they are lower in the ASCII order (or Unicode code point order) than capital letters.
Certainly if I use = in a comparison it is case sensitive.
Basically that filter seemed to be behaving as if I had used:
Upper('a')
Is this expected behaviour? A bug? Something I don't understand about Unicode characters?
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.