[V4RB 0000109]: SplitToWords misses apostrophe

jda jda at his.com
Tue Nov 16 15:52:19 CST 2004


>On Nov 16, 2004, at 15:25, jda wrote:
>
>>select id,hit from thereferences where ((left(allFields, 
>>6)='o'shea')) order by id
>
>I assume you're escaping o'shea?

:-)

I wasn't, but I did that about 10 minutes ago and now it is found.

>
>Is capitalization an issue?
>

No. With collationStrength = 0 searches are case-insensitive.

Seems to work now. As I said, as long as things are consistent we'll 
be fine -- and I prefer that apostrophes NOT be word breaks (which 
they were in Valentina 1.x). No, the ICU guys aren't dumb...

Jon


More information about the Valentina-beta mailing list