search in web site

  • Thread starter Thread starter miladhatam
  • Start date Start date
M

miladhatam

hi
i want the sql script of search in a field of database
of course i've written this scipt but in Unicode search it dosen't
work
select * from Table1 where tex like '%" +
Request.QueryString["search"].ToString() + "%' or topic like '%" +
Request.QueryString["search"].ToString() + "%'


thanks
 
% in sql means match more than one word.

select * from Table1 where tex like '[%]" +
Request.QueryString["search"].ToString() + "[%]' or topic like '[%]" +
Request.QueryString["search"].ToString() + "[%]'

try it!
 
hi
i want the sql script of search in a field of database
of course i've written this scipt but in Unicode search it dosen't
work
select * from Table1 where tex like '%" +
Request.QueryString["search"].ToString() + "%' or topic like '%" +
Request.QueryString["search"].ToString() + "%'

thanks
Click to expand...

Have you tried to create a full text catalog on the field you wish to
search on, this may allow you unicode searches. You can create these
via enterprise manager on the database node, it is then just up to you
to implement the full text search on the programming side which is
very simple :)
 
Back
Top