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

[lady_teacher]

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 :-)

[tsimpo]

read this post:

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

and if you have any questions feel free to reply this thread.

[lady_teacher]

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

[tsimpo]

you are welcome!!!

[lady_teacher]

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

[tsimpo]

export sql file from database

convert it with a text editor that supports utf-8 and import it to mysql again.

[lady_teacher]

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

Thanks