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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users