nukeSEO.com - PHPNuke SEO Search engine optimization, professional tools including nukeSEO, nukeSPAM, nukeFEED, nukePIE, nukeWYSIWYG and more

 

. Welcome to nukeSEO.com  ! 
.
.
.

Tag This



.
nukeSEO.com: Forums


 Forum FAQForum FAQ   SearchSearch   UsergroupsUsergroups   ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

utf-8 issue with intl. chars in title
 
 
Post new topic   Reply to topic    nukeSEO.com Forum Index -> nukeFEED (tm)
View previous topic :: View next topic  
Author Message
Brujo
webmaster


Joined: Sep 03, 2006
Posts: 20

PostPosted: Sat Apr 04, 2009 4:16 pm    Post subject: utf-8 issue with intl. chars in title Reply with quote

First, i started to test my site with utf-8 as charset, therefore i did a testinstallation and checked what happens and I found some issue with the feed if in the title are intl. chars

thats my startingpoint:
Ravennuke 2.30.01 - charset utf-8
mysql Kollation & tables: utf8_general_ci
the mysql dump i converted via iconv

in the Article Title which is shown correct i have:
Quote:
Tepoztln - Hauptstadt des Eis
or
Jos Mara Bocanegra: 1787- 1862


in the DB it is saved as:
Quote:
Tepoztlán - Hauptstadt des Eis
or
José María Bocanegra: »1787- 1862«


the feed also shows
Quote:
Tepoztlán - Hauptstadt des Eis
or
José María Bocanegra: »1787- 1862«


i tested it with true & false for nf_CONVERTENCODING in the rnconfig

any hint what can be wrong?

Brujo
  

Last edited by Brujo on Fri Apr 10, 2009 1:00 pm; edited 1 time in total
Back to top
View user's profile Send private message
kguske
Site Admin
Site Admin


Joined: May 12, 2005
Posts: 875

PostPosted: Sat Apr 04, 2009 9:34 pm    Post subject: Reply with quote

The feed doesn't convert the data. The problem is storing the data. Not sure if your database support UTF-8 or if there is a problem storing it.
_________________
  
Back to top
View user's profile Send private message Visit poster's website
Brujo
PostPosted: Sun Apr 05, 2009 2:33 am    Post subject: Reply with quote

thanks for answer, but now i am confused or in other word how should it be stored in the Db...

MySQL charset: UTF-8 Unicode (utf8)
the table Collation & field Collation is utf8_general_ci

so i create a new article with the following in the title:
Quote:
---------
and the Article is displayd fine, the sourcecode from the article is
Quote:
<td><div><font>---------</font></div></td>


the intl. Chars are saved in the DB looks like:

Quote:
Ö-Ä-Ü-ö-ä-ü-ß-é-á-í


which sould be correct UTF-8 as far as i know, and thats now my point i have no idea whats wrong

the preview feed for Articles under /modules.php?name=Feeds&fid=1&type=HTML
shows the intl. chars wrong and in the source from the feed is:
Quote:
<div><a>Ö-Ä-Ü-ö-ä-ü-ß-é-á-í</a></div>


what else i can check to find out whats wrong on my testsite?

Brujo
  
Back to top
kguske
PostPosted: Sun Apr 05, 2009 8:50 am    Post subject: Reply with quote

I misunderstood your first post. I thought the article did not display correctly. I am not sure how to resolve this, but I will check. When we tested this originally, Susann tested it for use with international characters, but I'm not sure if she was using UTF-8.
  
Back to top
Brujo
PostPosted: Sun Apr 05, 2009 9:42 am    Post subject: Reply with quote

no problem, sometimes pictures shows more as I am able to describe Smile

I already have my productiv site Only registered users can see links on this board! Get registered or login! with iso charset running without probs and valid with intl. chars, but on my testsite wich i like to have all under utf-8 for some reasons, i got the issue Only registered users can see links on this board! Get registered or login!.

so dont hurry i was just asking if that was a known issue / behavior and I will contact Susann maybe it would be got to be not alone with that...

Brujo
  
Back to top
Guardian
webmaster


Joined: Dec 25, 2005
Posts: 364
Location: Vsetin, Czech Republic

PostPosted: Mon Apr 06, 2009 5:27 pm    Post subject: Reply with quote

It is almost as if the entity is being changed for an alternative entity. Normally with this sort of problem you see a ? or diamond.

Out of curiosity, what happens when you post a comment on the article?
_________________
Only registered users can see links on this board! Get registered or login!
  
Back to top
View user's profile Send private message
Brujo
PostPosted: Tue Apr 07, 2009 5:46 am    Post subject: Reply with quote

the comment as well as the article looks fine with german Umlauts & Intl. Chars, see Only registered users can see links on this board! Get registered or login!

@guardian, you are right with the Question mark / Diamond thiss was happens on the first tests on many places like Survey & FAQ...


Brujo
  

Last edited by Brujo on Fri Apr 10, 2009 1:09 pm; edited 1 time in total
Back to top
Brujo
PostPosted: Wed Apr 08, 2009 12:14 am    Post subject: Reply with quote

one question, what would be a good and easy test / pice of code to see that content is saved correctly as UTF-8 in the DB and proberly displayed on the Browser to eleminate some parts of the chain.

Brujo
  
Back to top
Brujo
PostPosted: Fri Apr 10, 2009 12:22 pm    Post subject: Reply with quote

Hello kguske & Guardian

i was playing around on my test site and disabled the line ~134 in the /includes/nukeSEO/nukefeed.php

Quote:
if ( function_exists('mb_convert_encoding') )
{
// $title = mb_convert_encoding($title, 'UTF-8');
$desc = mb_convert_encoding($desc, 'UTF-8');


now the feed looks fine and is valid, maybe thats helps you a bit, because i didnt know why thats happens...

does this means that if a DB, collation ,tables and the content & charset is already in UTF-8 the mb_convert_encoding breaks it then?


Brujo
  
Back to top
Display posts from previous:       
Post new topic   Reply to topic    nukeSEO.com Forum Index -> nukeFEED (tm) All times are GMT - 5 Hours
 
 Page 1 of 1

 

Jump to:   
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum

Powered by phpBB © 2001-2008 phpBB Group


Page Generation: 0.15 Seconds