On Mon, Apr 26, 2010 at 8:23 PM, Simon Slavin <slav...@bigfraud.org> wrote:
>
> 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.
>
>
Michal and Simon, Yes this is what Igor pointed out too.
Igor, I am sorry I havent had the chance to write a test to check Hex values
dump yet.
by the way I used the dash on my keyboard which is next to the number 0 if
that helps what you guys are talking about. I use eclipse or notepad++ on
windows and Nano on Linux to code as I move from place to place. all of them
show me a dash that works everywhere. in fact when I place the values
retrieved from SQlite Select * query, on the telnet request to a server I
get the reply correctly for the values containing dash. for some reason only
SQLite2 is reporting what no else can see. Let me get that Hex dump so
things will get clearer. thanks a lot
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
