Brian,
I assume you are using MyISAM tables. The reason
for your problem probably is that your computer
does not give the latin1 codes to the accent
characters you type in. For example, the DOS
prompt in Win NT gives them different codes from
latin1, and consequently a similar test fails on
my NT machine.
InnoDB tables currently order latin1 characters outside
the ranges a-z and A-Z according to their numerical
code. I will change it in .43 so that they are ordered
in the same way as in MyISAM. Ar least one problem still
remains after that: MyISAM identifies an u with two
dots on it with the letter y, but in Brazil, I have been
told, it should be the same as plain u.
Regards,
Heikki
http://www.innodb.com
>Hello,
>
>I read that version 3.23 and later do accent insensitive searches when
>using LIKE in the query.
>
>However, I'm still having problems getting accent insensitive searches to work.
>
>I made a test page: http://www.sedl.org/accents.html
>
>to search a small database of names. There are four names, each entered
>twice, with one version of each name including an accent over one of the
>vowels.
>
>When I search for Jose (with accented e) it finds the unaccented Jose, but
>not the accented version.
>
>Very strange. Is this a characterset issue? or some other setting?
>
>The system says its running MySQL 3.23.41
>Client characterset: latin1
>Server characterset: latin1
>
>Any help would be greatly appreciated
>
>Thanks,
>Brian
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
