On Mon, Apr 26, 2010 at 11:28 AM, Igor Tandetnik <[email protected]>wrote:
> jason d wrote: > > I believe you misunderstood my problem. Its not that records dont exist. > and > > select statement for Bob does work. a select * does display all the data. > > its the names with dashes that dont shows up. and i have 40,000 records. > > any with dashes do not give any result on a pure select statement. but if > I > > select on any other column and then work on the resultset it is ok. for > > example I may choose column projectname since it does not have a dash (-) > in > > it. The information is clearly there, just its as if it does not equate > to > > anything at all. > > > > SELECT * from Groups WHERE name = 'jean-baptiste' ; zero result. > > What does this statement return: > > select name, hex(name) from Groups > where name like '%jean%'; > > My guess is, you either have leading and/or trailing whitespace around the > value, or the dash in the middle is not U+002D (HYPHEN-MINUS) but some other > Unicode character that looks like a dash, e.g. U+2013 (EN DASH). The hex > dump would tell. > -- > Igor Tandetnik > > this is what I got. I am using SQLite version 2.8.17 SQL error: no such function: hex _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
