Re: incorrect results with WHERE clause on table with accented characters

[mb33140]

Hello Heiki,

I'm using the latest MySql from Debian-- 4.0.23_Debian-1-log. What's confusing me is that when I read the mysql docs, everything about collation and character sets says it's for 4.1 and later. And it says in chapter 10 "Character set support currently included ... (as of MySQL 4.1.2) InnoDB storage engines", implying that the MySQL in Debian has *no* character set support for InnoDB. But if that's the case, how is U umlaut being translated as Y? Does that mean that before 4.1.2 InnoDB was 'hardcoded' to Swedish collation and cannot be changed?

We're releasing a media database engine and I was hoping to just make it use the regular latin set and treat any accented characters as unaccented characters, since that type of searching seems to be universally accepted. I know the french are accustomed to e accent agu/grave being sorted like e, and our Romanian programmers also say they are used to software treating accented characters like the unaccented ones. And our customer in Switzerland also says he would expect all the accented characters (like U umlaut) to be treated that way too. Is there a way to just use this as the default behavior? Otherwise it will be very difficult. The media database will include some artists from Sweden, some from the U.S., some from Germany, etc. To try to set record-level character sets would be a nightmare. And very confusing if a Swedish group that started with U umlaut appeared under Y while a German group with U umlaut appeared under U. And I don't even see mention of record-level character set, so we'll need one that's universal across all languages using the latin alphabet. Thank you for your help.