UTF-8 problem ... something to do with the database

Moderators: Aris Ntatsis, geof

Locked
User avatar
lady_teacher
Joomla! Apprentice
Joomla! Apprentice
Posts: 8
Joined: Tue Jun 24, 2008 2:07 pm
Location: Cyprus

UTF-8 problem ... something to do with the database

Post by lady_teacher » Sun Nov 16, 2008 11:57 am

Hi,

I seem to have a problem with UTF-8. I am trying to make my website display both Greek and English text. I have set the character encoding on my template to UTF-8 and my database tables are utf8_unicode_ci.
Everything looks ok to the eye on any browser but it seems that the greek text is saved on the database in the following format:

Code: Select all

Εξειδικευμένο προσωπικό


As a result search engines cannot recognize the text in Greek. :'(

My Joomla version is 1.0.13

Can anyone please help me with this?

***** Manual signatures are NOT allowed *****_____
-- Joomla rocks
-- Lady_teacher
-- Lets chat :-)
-- Joomla rocks
-- Lady_teacher
-- Lets chat :-)

User avatar
tsimpo
Joomla! Guru
Joomla! Guru
Posts: 527
Joined: Thu Sep 15, 2005 5:09 am
Location: Greece
Contact:

Re: UTF-8 problem ... something to do with the database

Post by tsimpo » Tue Nov 18, 2008 1:37 pm

read this post:

http://forum.joomla.org/viewtopic.php?t=55065

and if you have any questions feel free to reply this thread.
Joomla sites. http://www.webcase.gr Υπηρεσίες Internet, websites, Joomla! dedicated services.

User avatar
lady_teacher
Joomla! Apprentice
Joomla! Apprentice
Posts: 8
Joined: Tue Jun 24, 2008 2:07 pm
Location: Cyprus

Re: UTF-8 problem ... something to do with the database

Post by lady_teacher » Tue Nov 18, 2008 3:24 pm

thank you that really helped. I had to uncomment the

Code: Select all

@mysql_query("SET NAMES 'utf8'", $this->_resource);
in the includes/database.php file on line 102.

Thank you thank you :) :)
-- Joomla rocks
-- Lady_teacher
-- Lets chat :-)

User avatar
tsimpo
Joomla! Guru
Joomla! Guru
Posts: 527
Joined: Thu Sep 15, 2005 5:09 am
Location: Greece
Contact:

Re: UTF-8 problem ... something to do with the database

Post by tsimpo » Wed Nov 19, 2008 3:01 pm

you are welcome!!! :)
Joomla sites. http://www.webcase.gr Υπηρεσίες Internet, websites, Joomla! dedicated services.

User avatar
lady_teacher
Joomla! Apprentice
Joomla! Apprentice
Posts: 8
Joined: Tue Jun 24, 2008 2:07 pm
Location: Cyprus

Re: UTF-8 problem ... something to do with the database

Post by lady_teacher » Wed Nov 19, 2008 5:19 pm

Ok now I have a new problem :-). I constructed my whole website without the utf-8 encoding on database communication and now I have to convert all my content with the new encoding.

Is there an easy way to do the conversion ... other than copying pasting my pages one by one, or is a lot to ask heh? :-D
-- Joomla rocks
-- Lady_teacher
-- Lets chat :-)

User avatar
tsimpo
Joomla! Guru
Joomla! Guru
Posts: 527
Joined: Thu Sep 15, 2005 5:09 am
Location: Greece
Contact:

Re: UTF-8 problem ... something to do with the database

Post by tsimpo » Thu Nov 20, 2008 7:21 pm

export sql file from database

convert it with a text editor that supports utf-8 and import it to mysql again.
Joomla sites. http://www.webcase.gr Υπηρεσίες Internet, websites, Joomla! dedicated services.

User avatar
lady_teacher
Joomla! Apprentice
Joomla! Apprentice
Posts: 8
Joined: Tue Jun 24, 2008 2:07 pm
Location: Cyprus

Re: UTF-8 problem ... something to do with the database

Post by lady_teacher » Thu Nov 20, 2008 9:33 pm

hmmm ok i'll give it a shoot :-).

Thanks :D
-- Joomla rocks
-- Lady_teacher
-- Lets chat :-)


Locked

Return to “Joomla! 1.0.x”