SQL search

[jda]

>>>
>>
>>Can you check for UTF16 ?
>>
>
>UTF16 doesn't work, either. All 19 records are still found...
>

BTW, I found another couple of issues with SQL 
searching (tell me if we're not supposed to be 
checking this yet).

1. If I set the .collationAttribute to 2, 
searches are case sensitive! I thought that the 
"secondary" case was case insensitive.

2. If I set the .collationAttribute to 1, the 
search finds every record in the database, 
regardless of what I type in.

3. Searches for words containing unicode 
characters (e.g. tést) fail (.collationAttribute 
= 2, UTF-8 database).

Jon