shivaramrulz / anywhereindb

Automatically exported from code.google.com/p/anywhereindb
0 stars 0 forks source link

Wrong test for field type #8

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
The test for fields to search checks only if the first 7 characters include 
'varchar' or 'text'. That means the following types will not be searched:

char
longtext
mediumtext
tinytext

Change this line:

if(substr($collum[$j]['Type'],0,7)=='varchar'|| 
substr($collum[$j]['Type'],0,7)=='text')

to at least:

if(substr($collum[$j]['Type'],0,7)=='char'|| 
substr($collum[$j]['Type'],0,10)=='text')

You may also consider the binary, varbinary, and blob types too.

Original issue reported on code.google.com by sno...@gmail.com on 2 Oct 2010 at 2:14

GoogleCodeExporter commented 9 years ago
Um, of course not =='char' or =='text', but using stristr instead.

Original comment by sno...@gmail.com on 15 Oct 2010 at 12:45

GoogleCodeExporter commented 9 years ago
Now we are searching in all fields ! 

Original comment by happ...@gmail.com on 22 Dec 2010 at 4:49