Hi,

I am trying to create a public userlist on my site, and in that list I want to display some other e-mail address than the users private e-mail. As an example, on the public userlist the chairmans e-mail would be chair@mysite.com rather than firstname.lastname@mysite.com.

I have a multicheckbox (cb_boardmember) where one of the options is "Chairman", and I then create a delimiter field called cb_publicmail where I use the following substitution:

[code:1][cb:if cb_boardmember ="Chairman"]chair@mysite.com[/cb:if][/code:1]

This works like a charm and all I need to do is to display the delimiter field cb_publicmail in one of the columns of the userlist.

Now to my problem... My site is in swedish and chairman in Swedish is "Ordförande". The above code does not work when special characters are used. Is there any way to work around this? I have tried the following:

-using "%F6" instead of "ö" in the if-statement
-using LIKE "Ordf%" in the if-statement

Any help is greatly appreciated,
Stefan

Post edited by: palmqviststefan, at: 2010/09/11 09:28

Post edited by: krileon, at: 2010/09/20 15:10

OK, here is what I find.

The term "Ordförande" is being stored as exactly that in the fieldtitle of #_comprofiler_field_values. The collation is utf8_general_ci.

But the substitution I am putting into the description in #_comprofiler_fields is stored as

[code:1]Ordförande[/code:1]

The table collation is the same.

/Stefan

Post edited by: palmqviststefan, at: 2010/09/11 12:18

Hi,

turned out that my issues were a consequence of the editor I have installed on my site, JCE-Joomla Content Editor. The editor was saving the special characters in html-format. Once I installed and activated the Swedish plugin for the editor, it saved the special characters as it should.

Krileon, that code is exactly what I as using. Sorry for not explaining better. But the editor was still saving the special character in html-encoded format.

Many thanks for your help, please consider this topic as solved.

/Stefan