SQL search

[jda]

>
>  >
>>  This search
>>
>>   myDatabase.SQLSelect("select varCharField from misc where
>>  propertyName='groupName' ORDER BY varCharField"
>>
>>  returns all 19 records, even though only one of them has a
>>  propertyName of 'groupName'.
>>
>>  What is wrong with the select statement (or is this a bug in 2.0)?
>
>I think bug.
>
>This was usual database,
>Or you have set UTF8 for it ?
>

It is set to UTF8.

Jon