For the record, the problems with the indexes turned out to be: 1. Use type INDEX not FULLTEXT. Ah.
2. Illegal mix of collations (ascii_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE). Oops. 3. Some publisher names have single quotes in them, and some have regular quotes. So I can't figure out how to make an SQL call that will work for both. You can do this: Publisher = "Nobel Laureates' meeting" Publisher = "Pis'ma Zh. Teor. Fiz." But not this: Publisher = "Third International Conference on Cold Fusion, "Frontiers of Cold Fusion"" That crashes with an error. Not sure how to deal with that, other than going through the database of publisher names and eliminating single or double quotes. . . . This is why computers are still so hard to program. I expect commercial databases such as the one Amazon.com is renting out do not have such problems. MySQL costs nothing. It is more or less the same kind of thing we had back in 1982. - Jed
