Issues with selecting special characters

  • Resolved dan902

    (@dan902)


    8 years, 1 month ago

    Hello!

    I have an issue regarding selecting users that have for example an “ö” in their last name.
    I have tried to search for this issue that has been resolved already, but using the search bar didn’t result in anything unfortunately.

    When the user gets added to the database, the value gets stored correctly.
    Even using a SELECT statement in phpmyadmin I get the result I want, the user with the special character in its last name.

    Unfortunately I do not get this result when I try to search using this shortcode
    [pdb_list suppress=true search=true template=multisearch]

    Searching works fine for all other entries, except for the one with the special character “ö” in its last name.

    The collation for the tables:
    – wp_participants_database
    – wp_participants_database_fields
    – wp_participants_database_groups
    are all set to utf8_unicode_ci

    note that I was told to try to fix this, so I don’t know if the collations are this by default or if they were changed.
    Plus I’m pretty new to this, I’m doing this for internship.

    Thanks in advance!

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Author xnau webdesign

    (@xnau)

    8 years, 1 month ago

    After investigating this issue, I found that in order for the plugin to search using characters such as ‘ö’ and to be able to distinguish ‘ö’ from ‘o’ the collation of the storage fields should be set to the language used.

    It’s also possible to use the “binary” collation, which will compare all characters exactly.

    This needs to be set in the database directly, using a tool such as phpMyAdmin, which is typically found in your hosting control panel.

    If you look at the main data table for the plugin, usually named wp_participants_database, under the ‘structure’ tab, you’ll see that each column has a collation value of ‘utf8_unicode_ci’ which is the generic collation. Change the collation of all fields where such characters will be found (you don’t need to do them all) to ‘utf8_bin’ or to the collation that matches your language.

    This will also affect the alphabetical sorting of fields.

    Thread Starter dan902

    (@dan902)

    8 years, 1 month ago

    Hello!

    I have tried to use the collations you suggested but still no luck.

    I have tried the collation latin1_german1_ci AND latin1_german2_ci but even those did not work.
    It did not change the entry with the “ö”, but selecting it via the multisearch still did not work.

    I have no clue what collation to choose.
    As far as I know we’re only importing normal letters, except this one entry with the German accent “ö”.

    Do you perhaps have more suggestions for collations to use for this?

    Thanks.

    • This reply was modified 8 years, 1 month ago by dan902. Reason: (spelling mistake)
    Plugin Author xnau webdesign

    (@xnau)

    8 years, 1 month ago

    You must use utf8, not latin1

    Thread Starter dan902

    (@dan902)

    8 years, 1 month ago

    I have tried to use the UTF8 collation you suggested, I thought maybe use a collation that had german in the name since you said “or to the collation that matches your language.”

    But UTF8_bin did not make it work unfortunately.

    Plugin Author xnau webdesign

    (@xnau)

    8 years, 1 month ago

    If you are using the “whole word search” with the Combo Multisearch add-on, you’ll need to update to the latest version, it was having an issue with non-English characters in the search.

    Thread Starter dan902

    (@dan902)

    8 years, 1 month ago

    Hi Roland,

    I see you rolled out an update of the plugin.
    It is now indeed working, thanks!

Viewing 6 replies - 1 through 6 (of 6 total)

The topic ‘Issues with selecting special characters’ is closed to new replies.