Welcome to Centmin Mod Community
Register Now

Xenforo The official xenforo website and this website can do Chinese search

Discussion in 'Forum software usage' started by modder, Jun 17, 2020.

  1. modder

    modder Member

    40
    3
    8
    Dec 6, 2019
    Ratings:
    +6
    Local Time:
    3:22 AM
    But my centmin based Xenforo cannot. What could be the cause?
     
  2. eva2000

    eva2000 Administrator Staff Member

    44,702
    10,193
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +15,795
    Local Time:
    5:22 AM
    Nginx 1.17.x
    MariaDB 5.5/10.x
    Xenforo 1.5 or 2.x ?

    Can you do chinese search on my forums ? I am using Xenforo Enhanced search via Elasticsearch and I believe official Xenforo forum is too.
     
  3. modder

    modder Member

    40
    3
    8
    Dec 6, 2019
    Ratings:
    +6
    Local Time:
    3:22 AM
    Yes I posted a thread in the test forum. No problem with Chinese searching, title and inline. The same for official website.

    I'm using centmin, Xenforo Enhanced search via Elasticsearch too.

    Anything need to be changed in the DB settings?
     
  4. eva2000

    eva2000 Administrator Staff Member

    44,702
    10,193
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +15,795
    Local Time:
    5:22 AM
    Nginx 1.17.x
    MariaDB 5.5/10.x
    Have you asked on Xenforo support forums ?

    Might depend on character set and collation of your MariaDB server and Xenforo database/tables. For my forums on XF 1.5 I am using UTF8. I believe Xenforo.com on XF 2.1 switched to UTF8MB4 for emoji support. Centmin Mod 123.09beta01 defaults to UTF8 too for MariaDB 10.3 installs.

    Character set collation for MariaDB server can be checked as per MariaDB MySQL - CentminMod.com LEMP Nginx web stack for CentOS via SSH command
    Code (Text):
    mysqladmin var | grep -E 'character|collation' | tr -s ' '
    

    which gives me
    Code (Text):
    mysqladmin var | grep -E 'character|collation' | tr -s ' '
    | character_set_client | utf8 |
    | character_set_connection | utf8 |
    | character_set_database | utf8 |
    | character_set_filesystem | binary |
    | character_set_results | utf8 |
    | character_set_server | utf8 |
    | character_set_system | utf8 |
    | character_sets_dir | /usr/share/mysql/charsets/ |
    | collation_connection | utf8_general_ci |
    | collation_database | utf8_general_ci |
    | collation_server | utf8_general_ci |
    | session_track_system_variables | autocommit,character_set_client,character_set_connection,character_set_results,time_zone |
    
     
  5. modder

    modder Member

    40
    3
    8
    Dec 6, 2019
    Ratings:
    +6
    Local Time:
    3:22 AM
    I'll check that out and maybe I'll seek help in xenforo I can't find a solution. Thanks a lot!