Skip to content

Non latin characters issue  #54

Description

@cod3box

Ok. I have an issue that i cant figure it out :(
My problem is that i use special characters in my language. What i mean is that in Greek Language the letters α, ά or ε, έ are the same letters but if you type the letter α in the search input field it doesn't highlight also the letters ά in the results list ! How can i force the plugin return results for both "α, ά" when i type "α" in the search input field and vice versa when i type "ά" to return both "α, ά" ??

This is very important in Greek Language or other non-latin languages like cyrillic etc.

Thanks!

Activity

  1. tgely commented on Jul 7, 2020

    @tgely

    Hi @cod3box ,
    I have similar problems with AJAX requests. MySql makes some jokes but I can figure out it with binary collations.
    I use utf8 character set with utf8_bin collation but it could be utb8mb4 charset with utf8mb4_bin collation.

    Examples in mysql query script language

    select pd.* 
    from products_description pd
    where
     lower(pd.products_name) like '%lá%' collate utf8_bin;
    
    --  Error Code: 1253. COLLATION 'utf8_bin' is not valid for CHARACTER SET 'utf8mb4'
    
    select pd.* 
    from products_description pd
    where
     lower(pd.products_name) like '%lá%' collate utf8mb4_bin;
    
    -- OK

    When you use javascript arrays on utf8 codepage in html then code text file in utf8 without BOM.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions