On 26 Apr 2010, at 1:04pm, Michal Seliga wrote: > i had similar problems and it was caused by microsoft office > it didn't used ordinary dash but some strange character with different > ascii code - so search based on it always failed > i had to convert these strange dashes to ordinary ones to make it work > try, maybe this is also your case
Good catch. MS Office, under some circumstances, automatically replaces the '-' (minus sign) character with a hyphen ('‐'). Technically the hyphen is the right character to use to join two words, but since it doesn't have an easy key-combination many people don't type it and like the automatic conversion that Office does. Annoyingly neither of these are actually dashes: there are n-dash ('–') and m-dash ('—') characters too. So there are four characters that all look similar but do not have the same hash value in normal text processing. Simon. PS: Don't get me started on figure-dashes and graphical horizontal lines. Unicode should not include graphical icons. Bah humbug. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users