FeedForAll Forum Index  
 Home  •  FAQ  •   Search   •  Register   •  Profile   •  Log in
 Greek encoding View next topic
View previous topic
Post new topicReply to topic
Author Message
chmanos



Joined: 04 Mar 2014
Posts: 5

PostPosted: Tue Mar 04, 2014 8:56 am Reply with quoteBack to top

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.
View user's profile
Tech Support



Joined: 27 Aug 2004
Posts: 2783

PostPosted: Tue Mar 04, 2014 9:00 am Reply with quoteBack to top

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.

_________________
Create RSS Feeds
Audio Recording and Editing
View user's profile
chmanos



Joined: 04 Mar 2014
Posts: 5

PostPosted: Tue Mar 04, 2014 9:07 am Reply with quoteBack to top

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.
View user's profile
Tech Support



Joined: 27 Aug 2004
Posts: 2783

PostPosted: Tue Mar 04, 2014 9:18 am Reply with quoteBack to top

Email them to support at feedforall dot com

Also, what's the URL of your site?

_________________
Create RSS Feeds
Audio Recording and Editing
View user's profile
chmanos



Joined: 04 Mar 2014
Posts: 5

PostPosted: Tue Mar 04, 2014 9:33 am Reply with quoteBack to top

Dir sir,

I sent the files to your email

Thank you.
View user's profile
Tech Support



Joined: 27 Aug 2004
Posts: 2783

PostPosted: Tue Mar 04, 2014 4:16 pm Reply with quoteBack to top

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';

_________________
Create RSS Feeds
Audio Recording and Editing
View user's profile
chmanos



Joined: 04 Mar 2014
Posts: 5

PostPosted: Tue Mar 04, 2014 4:58 pm Reply with quoteBack to top

Thank you for your reply.

I have done it already.

Still the same problem.
View user's profile
Tech Support



Joined: 27 Aug 2004
Posts: 2783

PostPosted: Wed Mar 05, 2014 5:04 pm Reply with quoteBack to top

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

_________________
Create RSS Feeds
Audio Recording and Editing
View user's profile
chmanos



Joined: 04 Mar 2014
Posts: 5

PostPosted: Thu Mar 06, 2014 12:24 am Reply with quoteBack to top

That was the problem.

The hosting company had changed the encoding without notice.

The problem is solved.

Thank you all.
View user's profile
patra88



Joined: 09 Nov 2014
Posts: 1

PostPosted: Sun Nov 09, 2014 4:10 pm Reply with quoteBack to top

[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.
View user's profileVisit poster's website
Display posts from previous:      
Post new topicReply to topic


 Jump to:   



View next topic
View previous topic


Powered by phpBB © 2001, 2002 phpBB Group :: FI Theme