MYSQL Character Accents

[Guest_imported]

I saw in the MySQL change log for version 3.23 that MySQL now supports case-insensitive searches, but it doesn't seem to be working correctly for me.
I made a test page:

http://www.sedl.org/accents.html

which can search a small database of names. There are four names, each entered twice, and one version has 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

 

[Cagliostro]

the problem is what accented and non accented vowels are different characters which only look as the same but with accent. Ion Filipski

filipski@excite.com