On 4/17/07, Marc Weustink <[EMAIL PROTECTED]> wrote:
Fixed.
The database was configured with a default collation of utf8_bin. This
means that every table and every string field defaults to a case
sensitive sorting. With the result that the LIKE operator also becomes
case sensitive (I didn't find this in the mysql docs)
I changed the collation for those fields where search works on
Thanks Marc! It works perfectly now and should minimize duplicate bug reports.
--
Graeme Geldenhuys
There's no place like S34° 03.168' E018° 49.342'
_________________________________________________________________
To unsubscribe: mail [EMAIL PROTECTED] with
"unsubscribe" as the Subject
archives at http://www.lazarus.freepascal.org/mailarchives
