+ Reply to Thread
Results 1 to 2 of 2
  1. Junior Member
    Join Date
    Nov 2003
    Posts
    1
    #1

    Default Full Text index (catalog accent sensitive problems)

    I have a Windows 2000 Server with Microsoft SQL Server 2000.

    I have a Modern Spanish AI CI database, and we can work with the index in this form. The catalog is well formed (spanish...) but i can't obtain Accent Insentive response with the full text index query.

    SELECT *
    FROM News
    WHERE CONTAINS(*, 'camion')

    With this form i can't obtein headlines with the "camión" spanish word.

    If i do the normal query

    SELECT *
    FROM News
    WHERE (titulo LIKE '%camión%')

    i obtein the Accent Insentive response with the "camión" spanish word.

    Can anybody hep me about this problem?????

    Thanks from Spain.
    Reply With Quote Quote  

  2. Senior Member
    Join Date
    May 2003
    Location
    Toronto
    Posts
    1,160

    Certifications
    MCSD, RHCSA
    #2
    Have u tried using Unicode characters?
    Reply With Quote Quote  

+ Reply to Thread

Social Networking & Bookmarks