SQL search

[jda]

>
>  >>>   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.
>
>Can you check for UTF16 ?
>

UTF16 doesn't work, either. All 19 records are still found...

Jon