Case insensitive LIKE search

Ivan Smahin IvanSmahin at public.kherson.ua
Wed Dec 14 20:40:46 CST 2005


Hello jda,

Wednesday, December 14, 2005, 6:57:01 PM, you wrote:

>>  > kStrength I have assigned (kPrimary)?
>>
>>But if you have assign or db Strength to be Primary,
>>then LIKE respect this of course!
>>

j> Hm, I have my db set to

j> CollationAttribute(EVColAttribute.kStrength) = EVColAttributeValue.kSecondary

j> But LIKE searches are still case sensitive (I have to surround the 
j> text with % to get case *insensitive* searches).

Strange.
Everything works here.

Ok. Could you send me a little project or database for testing?


-- 
Best regards,
 Ivan                            mailto:IvanSmahin at public.kherson.ua



More information about the Valentina mailing list