Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2009
    Posts
    5

    Unanswered: fuul text search

    hi
    i have a table with lname column with
    collation sql_latin1_general_cp1256_CI_AS
    and for search i use full text search

    i want to find a persian word like 'یخدانی'
    but when i write this query
    select * from tbl1 where freetext(lname ,'یخدانی' )
    dont retrive an answer
    because in this field in database 'یخدانی' saved as ' يخداني '
    please help me

  2. #2
    Join Date
    Nov 2009
    Posts
    4
    Quote Originally Posted by faranak_yakhdani View Post
    hi
    i have a table with lname column with
    collation sql_latin1_general_cp1256_CI_AS
    and for search i use full text search

    i want to find a persian word like 'یخدانی'
    but when i write this query
    select * from tbl1 where freetext(lname ,'یخدانی' )
    dont retrive an answer
    because in this field in database 'یخدانی' saved as ' يخداني '
    please help me
    Please try
    select * from tbl1 where freetext(lname ,N'یخدانی' )

  3. #3
    Join Date
    Nov 2009
    Posts
    5
    hi i tried with select * from tbl1 where freetext(lname,N'یخدانی')
    but is doesnt work

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •