Are you sure your db connection is using UTF-8?
BTW, I noticed an error in my last reply. It should be SET NAMES
'utf8'; (no '-')
On Thu, Aug 27, 2009 at 4:01 AM, danfreak<freakclimb...@gmail.com> wrote:
>
> the main encoding problem is in a shell script:
>
> The script imports RSS from 10 different sources once every hour and
> stores them in DB.
>
> In order to normalize the grabbed content I use:
> --------------------------------
> foreach ($feed->get_items() as $item){
> $myitem['title'] = trim($item->get_title());
> $myitem['title'] = trim($myitem['title'])!='' ? html_entity_decode
> ($myitem['title'], ENT_QUOTES, 'UTF-8') : $rssFont['name'];
> $myitem['content'] = $item->get_description();
> $myitem['link'] = $item->get_permalink();
> $myitem['pubDate'] = $item->get_date('Y-m-d H:i:s');
> $myitem['source_id'] = $rssFont['id'];
> $this->saveRetrievedData($myitem);
> }
> --------------------------------
>
> This works fine locally, while conversion is not going well remotely
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
