How to compare a field with accents with a field without accents?

[queryboy]

I need to compare two fields "Name" and "StudentName" and I am having problems with this, the values in the field "Name" do not contain accents but the values in "StudentName" contain accents in the names like 'Róbert' or 'Czuukó' and also names like 'Mary-Ann' so when I try to compare it will give me several matches because most of the names don't have accents but the ones that contain an accent in"Name" won't show up as matching with "StudentName"

[yuanliu]

There is no built-in function to do this conversion.  You can decide which character set your data is, and build your own.