Hi Martina

This is not very highlighted in help.

Would you mind to set an issue to
https://github.com/VFPX/HelpFile/issues

There need to be a change to
- SET COLLATE
- Relational Operators

Lutz

>Hi Lutz,
>
> SET COLLATE TO ... affects string comparation for operator "="
>
>SET COLLATE TO "GENERAL"
>?"GALA"= "Gala"
>?"A"= "a"
>SET COLLATE TO "MACHINE" && binary
>?"GALA"= "Gala"
>?"A"= "a"
>
>
>MartinaJ
>
>>Hi Martina,
>>
>>SET COLLATE should do nothing an a simple comparison?
>>I see no INDEX ON.
>>So you say this is some internal SQL indexing behaving oddly?