Il 10 marzo 2012 00:40, Jed Rothwell <[email protected]> ha scritto: > 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"" Try the following to escape the dobule quotes: Publisher = "Third International Conference on Cold Fusion, ""Frontiers of Cold Fusion"""
or the following: Publisher = "Third International Conference on Cold Fusion, \"Frontiers of Cold Fusion\"" hope that one works. > > 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. That is why you should start using PostgreSQL... Indeed MySQL is owned by the biggest (and expensive) DB maker around: Oracle... maybe they are just trying to promote their paid support or the commercial version? ;-)
