Fulltext MySQL search and Asian Language Code

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • anhtuancool
    New Member
    • Oct 2004
    • 6
    • 3.0.3

    Fulltext MySQL search and Asian Language Code

    These two seem not to go along very well. Asian typing displays fine on the forum but when a search is performed, mysql fulltext search could not find any. Vbulletin standard search, however, found some, but totally irrelevant.

    Any thoughts would be highly appreciated!
  • Scott MacVicar
    Former vBulletin Developer
    • Dec 2000
    • 13286

    #2
    You need MySQL 4.1.1+ to work with non Western character sets and the encoding of the tables needs to be set accordingly.
    Scott MacVicar

    My Blog | Twitter

    Comment

    • anhtuancool
      New Member
      • Oct 2004
      • 6
      • 3.0.3

      #3
      Originally posted by Scott MacVicar
      You need MySQL 4.1.1+ to work with non Western character sets and the encoding of the tables needs to be set accordingly.
      My PHP version is 5.0.5 already, and how do I do "encoding of the tables needs to be set accordingly"?

      Comment

      • Scott MacVicar
        Former vBulletin Developer
        • Dec 2000
        • 13286

        #4
        MySQL version needs to be 4.1.1+ not the PHP version.

        You can change the encoding within phpMyAdmin to the appropriate encoding that matches the encoding you already use.
        Scott MacVicar

        My Blog | Twitter

        Comment

        • anhtuancool
          New Member
          • Oct 2004
          • 6
          • 3.0.3

          #5
          Originally posted by Scott MacVicar
          MySQL version needs to be 4.1.1+ not the PHP version.

          You can change the encoding within phpMyAdmin to the appropriate encoding that matches the encoding you already use.
          I see. My MySQL version is 4.0.25-standard...I'll try to contact the host admin see if they can help upgrading...
          Great thank for helping!

          Comment

          widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
          Working...