Views broken when username contains special characters

Question

Hi,

I've created a couple views showing e.g. the latest news and events. However, when the username contains "special characters" (but still common in Finland), for example 'ä' or 'ö', the view shows the empty text instead of the real data.

For example my events view has two fields (node title and time of the event) and three filters (published = yes, node type = event and event time >= now). Nothing closely related filtering with the username added by myself.

Is there a workaround to get the view working?

Answer 1

Sounds like a problem with character encoding. I would recommend UTF8, works with almost every language.

The Absolute Minimum Every Software Developer Absolutely, Positively Must Know About Unicode and Character Sets

Whatever you do, make sure you use always the same encoding and use it everywhere.