V4RB 2.3 doesn't respect case-insensitivity when inserting new data

[Dave Addey]

Hi Ruslan,

> Q: you have set Strength = Primary for this one table only ?
>     or all your tables have the same settings?
> 
> If all the same then all you need is:
> 
>     db = new Vdatabase
>     db.Create  
>     db.SetCollationAttribute( kStrength ) = kPrimary

Actually, the code should be:

     db = new Vdatabase
     db.Create  
     db.CollationAttribute( EVColAttribute.kStrength ) =
EVColAttributeValue.kPrimary

...but it's the same principle :-)

> It sounds to me like JUST only created objects of Vtable do not pickup your
> settings into work. After close, on next open they correctly setup self
> reading info from sys tables.

Yes, this is correct.  However, I just tried the approach mentioned above,
and this solves the problem!  If I set the strength to Primary for the
database rather than for each table, then newly-created objects do pick up
the setting correctly.

> As I see to reproduce your bug it needs NOT your database, but YOUR or
> similar small project that
>     create db and tables and set settings
>     add records
>     do LIKE search  -> see problem
> 
> Agree ?

I agree!  Unfortunately this would take quite a while for me to do - and you
just suggested a better workaround... I'll try and do this if I get time,
but for now, the approach described above solves the problem for me.  Of
course, if I needed a *different* strength for one of the tables in the
database, then I would hit the bug again...

Thanks for the help,

Dave.