how? select statements matching accented characters

[Remco van den Berg]

I'm running a MySQL database with one of tables holding the members of a
volleybal club in the Netherlands.

One the the fields in that table is holding the name of the players.

How do I search for all people with the name "Andre", with the important
remark, that it should also match "André"!! So with the letter "e" with
an accent "'" on it.
In the Netherlands those names can be spelled with and without the
accent and I do not always know how the name should be spelled correctly.

The query I run at the moment is:

SELECT * FROM member WHERE name='Andre';

But that does not match the names with accents on the characters.

Any help appreciated, regards,

Remco van den Berg

[Leif]

"Remco van den Berg" <rv*****@kemphaan.dekelen.veldhoven.nl> skrev i en
meddelelse news:slrncm7rfl.1g5k.rv*****@kemphaan.dekelen.veld hoven.nl...

I'm running a MySQL database with one of tables holding the members of a
volleybal club in the Netherlands.

One the the fields in that table is holding the name of the players.

How do I search for all people with the name "Andre", with the important
remark, that it should also match "André"!! So with the letter "e" with
an accent "'" on it.
In the Netherlands those names can be spelled with and without the
accent and I do not always know how the name should be spelled correctly.

The query I run at the moment is:

SELECT * FROM member WHERE name='Andre';

But that does not match the names with accents on the characters.

Strange. What datatype is name?
I made at test with a varchar, and "rene" matched both "Rene" and "René"

But if I changed the varchar to "varchar binary" only perfect matches were
found.
You didn't do that?

If you were so strange to have declared name as a blob, you would have the
same problem.

On the other hand, if you have "rene" = "René" and don't want it, you can
use cast(name as binary)
Eg
.... where cast(name as binary) = "René"

Leif
Keuf

[Remco van den Berg]

On Wed, 6 Oct 2004 18:21:34 +0200, Leif wrote:

How do I search for all people with the name "Andre", with the important
remark, that it should also match "André"!! So with the letter "e" with
an accent "'" on it.

Strange. What datatype is name?
I made at test with a varchar, and "rene" matched both "Rene" and "René"

OK, sorry, works now...
But now I have another question... :-)

I want to generate e-mail adresses out of the database in the format:

real.name <email@address>

But it is not allowed to use accented characters in this format.

Does there exist a MySQL statement which returns the name in which the
accented characters are converted to the non-accented characters?

I looked in the documentation but cannot find this...

Regards,

Remco