Support » Plugin: WP Business Intelligence Lite » Wrong Characters (German umlaute)

  • Resolved volksch

    (@volksch)


    Hello,

    since Update to 3.0.2 from 1.6.7 I get wrong characters from queries when the result contains german characters (Umlaute)
    It seems to be a Problem with character sets.
    The privious Version had no Problems with this characters.

    Thanks
    Volker

Viewing 4 replies - 1 through 4 (of 4 total)
  • Hi Voker,

    I looked into this, but I haven’t been able to recreate the issue. See image: https://i.imgur.com/aHeYdcZ.png.

    Could you explain the issue you’re having a bit more and I’ll continue looking into it.

    Regards,
    Kenton

    Thread Starter volksch

    (@volksch)

    Hi Kenton,

    I will try it.
    Here is my query:

    select date_format(event_date,'%d.%m.%Y') as Datum
          ,  title as Einsatz
    from ffhwp_v_events
    where category in ('bsd','brand','rescue')
    and YEAR(STR_TO_DATE(ffhwp_v_events.event_date,'%Y-%m-%d')) = YEAR(curdate()) order by event_date desc limit 3

    The test result in 3.0.2 on the admin page is:

    Array
    (
        [0] => Array
            (
                [Datum] => 22.02.2018
                [Einsatz] => Voraushelfer
            )
    
        [1] => Array
            (
                [Datum] => 17.02.2018
                [Einsatz] => Voraushelfer
            )
    
        [2] => Array
            (
                [Datum] => 12.02.2018
                [Einsatz] => Unterst�tzung Rettungsdienst
            )
    
    )

    The error is in the last value of [Einsatz]

    The same query in Version 1.6.7 gives the correct result.

    22.02.2018 Voraushelfer
    17.02.2018 Voraushelfer
    12.02.2018 Unterstützung Rettungsdienst

    The same behavor I have on the FrontPage.

    If you Need more Information contact me please.

    Many Thanks

    Regards,
    Volker

    Hi Volker,

    Sorry about misspelling your name in my last message.

    I’ve been looking into this but unfortunately I can’t reproduce the issue.

    What happens with the query: select ‘ü’

    What is the results of the following:
    SHOW VARIABLES LIKE ‘char%’;
    SHOW FULL COLUMNS FROM ffhwp_v_events;
    SHOW TABLE STATUS where name like ‘ffhwp_v_events’;

    Can you double check that on those pages you have the following in your html: <meta http-equiv=”Content-Type” content=”text/html; charset=UTF-8″ />

    Regards,
    Kenton

    Marking this as resolved for now, but I’d be happy to look into any character issues that come up in the future.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Wrong Characters (German umlaute)’ is closed to new replies.