V4RB 2.2 doesn't seem to respect case-insensitivity any more

[Dave Addey]

Hi Ivan,

I only set the collation value for the table, not for any of the fields.
So, in my VTable's Constructor, I have:

  // some other fields are created here
  
  SearchField = New VVarChar("SearchField", 1008)
  
  CollationAttribute(EVColAttribute.kNumericCollation) =
EVColAttributeValue.kON
  CollationAttribute(EVColAttribute.kStrength) =
EVColAttributeValue.kPrimary
  
...this is at the very end of the table constructor.

Any ideas?

Dave.

> From: Ivan Smahin <ivan_smahin at valentina-db.com>
> Organization: Paradigma Software, Inc
> Reply-To: Valentina Developers <valentina at lists.macserve.net>
> Date: Fri, 3 Mar 2006 10:51:17 +0200
> To: Valentina Developers <valentina at lists.macserve.net>
> Subject: Re: V4RB 2.2 doesn't seem to respect case-insensitivity any more
> 
> Hello Dave,
> 
> Friday, March 3, 2006, 1:49:22 AM, you wrote:
> 
>> Hi there,
> 
>> Since I moved over to V4RB 2.2, I¹m finding that my LIKE searches are no
>> longer case-insensitive.  I have a table whose collation attribute is
>> case-insensitive, but when I do:
> 
>> SELECT * FROM Tracks WHERE (Tracks.SearchField LIKE ?%u2%¹)
> 
>> ...then ³u2² is matched, but ³U2² is not.  I¹m sure this is different from
>> the behaviour I saw in V4RB 2.1.  Did anything change?
> 
> Probably that is the case:
> 
> http://www.valentina-db.com/dokuwiki/doku.php?id=paradigma:public:en:documenta
> tion:vkernel:faqs:faqs
> 
> -- 
> Best regards,
>  Ivan                            mailto:ivan_smahin at valentina-db.com
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina