Hello
CL I can't know this beforehand. These are just examples, i need a generic
CL solution if possivble.
CL All i can see so far is to build a table of all special characters ever
CL used in the 24000 names of cities which make problems and remap them
CL accordingly.
How about having an extra column for each column that you want to search
in? In the extra column, have a plain lowercase ASCII version of the word.
So, for 'Sào Paulo', have 'sao paulo'. You would need to write a small
program to convert the characters. When you want to search for something,
convert your search query into something without accents, and search in
the extra column.
This way, you preserve the accurate spellings of places, don't require all
users to know the spelling exactly, and can find places whatever the user
put in. You would just need to know that 'à' converts to 'a'.
Swithun.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users