Replacing LIKE with REGEX doubts

[Stan Busk]

Is it EVColAttributeValue.kPrimary like in:

myReference = new VvarChar ( "myReference", 64, EVFlag.fIndexed +  
EVFlag.fUnique + EVColAttributeValue.kPrimary )

If I edit those fields, should I also update schema on old database  
files? Is it?:

vdb.Table("myTable").Field("myField").CollationAttribute =  
EVColAttributeValue.kPrimary

Stan

>> Am I right if I continue using LIKE this way?:
>>
>>      Is equal to: myField LIKE 'mytext'
>> Is not equal to: myField NOT LIKE 'mytext'
>>         Contains: myField LIKE '%mytext%'
>> Doesn't contain: myField NOT LIKE '%mytext%'
>>      Starts with: myField LIKE '%mytext'
>>        Ends with: myField LIKE 'mytext%'
>>
>> Is new Valentina 2 LIKE case insensitive? or is it case sensitive?
>
> It is depend on Database/Table/Field settings.