?Greek encoding

chmanos · Joined: 04 Mar 2014 Posts: 5

Hi there,

I am a new user.

Several years ago, I got the rss2sql project, which was running excellent.
Yesterday, the hosting company did a system upgrade and since then, the Greek characters are not recognized and in the database I get ????? instead.

I believe that this comes from the mysql.

Do you have any suggestions?

Thank you
Chris.

Tech Support · Joined: 27 Aug 2004 Posts: 2688

Have the web server administrator check to see if your new website's encoding is in UTF-8 or ISO. It should be in UTF-8 and I think it's presently ISO, based on the description of your problem.

chmanos · Joined: 04 Mar 2014 Posts: 5

Thank you for your reply.

Well the thing is that everything is exactly like it was.
I haven't change or config something on the website, mysql etc.

Suddently the characters are stored as ?????.

Can I send you the files and the database structure so to see were I might have the problem?

My version is old, arround 2007-8.

Tech Support · Joined: 27 Aug 2004 Posts: 2688

Email them to support at feedforall dot com

Also, what's the URL of your site?

chmanos · Joined: 04 Mar 2014 Posts: 5

Dir sir,

I sent the files to your email

Thank you.

Tech Support · Joined: 27 Aug 2004 Posts: 2688

There might be a relevant setting in the rss2sql.php file. Near the beginning of the rss2sql.php file, look for the section below:

Code:

//
// Missing Encoding Default:? Some feeds do not specify the character set
// they are encoded in.? The XML specification states that if there is no
// encoding specified the XML file, all RSS feeds are XML, must be encoded
// in UTF-8, but experience has show differently.? This specifies the
// encoding that will be used for feeds that don't specify the encoding.
//$missingEncodingDefault = 'UTF-8';
$missingEncodingDefault = 'ISO-8859-1';

Try changing the last two lines to this:

Code:

$missingEncodingDefault = 'UTF-8';
//$missingEncodingDefault = 'ISO-8859-1';

chmanos · Joined: 04 Mar 2014 Posts: 5

Thank you for your reply.

I have done it already.

Still the same problem.

Tech Support · Joined: 27 Aug 2004 Posts: 2688

Next step would be to check that all your database tables are still set to use UTF-8 character encoding.

chmanos · Joined: 04 Mar 2014 Posts: 5

That was the problem.

The hosting company had changed the encoding without notice.

The problem is solved.

Thank you all.

patra88 · Joined: 09 Nov 2014 Posts: 1

[quote="Tech Support"]There might be a relevant setting in the rss2sql.php file. Near the beginning of the rss2sql.php file, look for the section below:

[code]
//
// Missing Encoding Default: Some feeds do not specify the character set
// they are encoded in. The XML specification states that if there is no
// encoding specified the XML file, all RSS feeds are XML, must be encoded
// in UTF-8, but experience has show differently. This specifies the
// encoding that will be used for feeds that don't specify the encoding.
//$missingEncodingDefault = 'UTF-8';
$missingEncodingDefault = 'ISO-8859-1';
[/code]

Try changing the last two lines to this:

[code]
$missingEncodingDefault = 'UTF-8';
//$missingEncodingDefault = 'ISO-8859-1';
[/code][/quote]

Thank you for the explanation. I also had the same problem. I will try.