Posted by Julien Demoor on 10/24/05 20:19

Hello,

My website is blog/news aggregator. It reads rss and atom feeds to store
and stores data in a mysql database. The feeds may use different
character encodings, generally utf-8 and iso-8859-1. The parsing script
knows from the database when it visits a utf-8 feed and uses the php
function utf8_decode before send information to mysql. This has been
working great for five month.
Without any noticeable change in the configuration or in the scripts, it
started to convert iso-8859-1 to utf-8 before sending the data to mysql,
which doesn't undestand unicode, so texts with accentuated characters
become unreadable.
Is it possible that the encoding of the php files cause such behaviour ?
Can you think of any other reason or solution ? Any help will be
appreciated.

Thanks in advance.


JD

• Next in forum: Re: Best approach to run queries only when user chooses
• Prev in forum: Re: displaying first 50 characters of a mysql text field?
• Thread view: Php4/Mysql and character encoding

[Reply to this message]