Hello,
I am designing a database for my school library.
10% of the books in the database are French, and thus have words with accents like Château.
My issue is that I'd like the user to search for book by typing Chateau (as it is too difficult to type in words with accents), however, when a list of results come back, it would appear as Château
My initial solution was to build a field for alternative names to do the search under
For example
TitleID: 1001
Title: Château
Alt_Title: Chateau
However, since only 10% of the books have accents, there would be 90% redundancy, as all the other books would look like this.
TitleID 1002
Title: Catcher in the Rye
Alt_Title: Catcher in the Rye
Is there a simpler solution?
Joel