[EventCalendar] ec3_get_calendar() not translating ampersands into character entities

[ejm]

This is how a post_title with an ampersand appears in both WP and in
SQL results:

Joan B. Kroc Institute for Peace & Justice Women

This is how a post_title with ’ (right single quote character) appears
in WP:

UN declares 2 October, Gandhi’s birthday, as International Day of
Non-Violence

and in SQL:

UN declares 2 October, Gandhi’s birthday 

(entry for Friday, 15 June 2007; event date 2 October 2007 ... the
June calendar is showing zero posts or events...)

In phpMyAdmin, instead of the symbol that uses the ’ character
entitey,  I see lower case "a" with a circumflex followed by the Euro
symbol followed by the Trademark symbol.

>Send me a copy of your eventcalendar3/day.php and template-functions.php 
>files, so I can see what you are running.

This is very kind of you to spend so much time on this, Alex! Thank
you. I will send a zipped folder containing copies of those two files
for both the kitchen blog and the peacemakers bulletins  to your email
address rather than the group.

-Elizabeth


On Fri, 12 Oct 2007 01:26:35 +0100, Alex Tingle wrote:

>ejm wrote:
>> What exactly am I looking for with the SQL " SELECT post_title FROM
>> wp_posts;"? 
>> 
>> Is it this sort of thing?
>> 
>> RECONCILATION – TELECONFERENCES
>
>Yes. That's a UTF-8 ndash character. How does that appear in WordPress?
>
>In your e-mail it looks something like aE" - the three bytes are 
>interpreted as ISO-8859-1 because your e-mail program has set the 
>encoding incorrectly.
>
>I've introduced that character into an event title in my test blog, and 
>everything seems to work fine.
>
>Some of your post titles come out with "&amp " - what do they look like 
>in MySQL?
>
>
>> There are a number of instances of this character "–" in the titles.
>> Is there some way that I can globally fix those using phpMyAdmin? Or
>> is it unlikely that they are what is causing this strangeness?
>> 
>> -E
>> 
>> P.S. It has to be something to do with the way I have installed either
>> wp or ec. This strangeness is also reproduced on my other wordpress
>> (the one that I author) etherwork.net/blog/  I just changed a title to
>> include an ampersand instead of the word "and".  Look for "apple &amp
>> lavender combination revisited" in the source code. Note that there
>> are two spaces between "&amp" and  "lavender" in the title spec. Is it
>> possible that ec is changing the semicolon into a nonbreaking space?
>
>Send me a copy of your eventcalendar3/day.php and template-functions.php 
>files, so I can see what you are running.
>
>-Alex
>