Wrong Characters (German umlaute)

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

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.