CREATING FULLTEXT INDEX problem

Discussion in 'MySQL' started by nebhotep, Mar 10, 2008.

0
  1. #1
    hi

    I have a table as follows

    id int(10)
    title varchar(150)
    text mediumtext
    data date
    sursa varchar(45)
    keywords varchar(100)
    impressions int(11)

    so I want to create a FULL text index on 3 column (title,text and keywords), but I keep receiving a error message

    Column 'title' cannot be part of FULLTEXT index
    Code (markup):
    This error persist even if I try to make single column index, on each of the interested columns

    any ideas?
     
    nebhotep, Mar 10, 2008 IP
  2. SoKickIt

    SoKickIt Active Member

    Messages:
    305
    Likes Received:
    30
    Best Answers:
    0
    Trophy Points:
    70
    #2
    This should help you.

    Although the use of multiple character sets within a single table is supported, all columns in a FULLTEXT index must use the same character set and collation.
     
    SoKickIt, Mar 11, 2008 IP
  3. nebhotep

    nebhotep Active Member

    Messages:
    244
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    80
    #3
    thanks for the help. it was a collation problem. I did not know that fulltext indexing does not allow UCS2.
     
    nebhotep, Mar 11, 2008 IP