encoding problem with multi-language website

[stepanek]

Hi to all,

 

I'm having big trouble getting a multi-language website working. The problem is that I can't get Czech, Romanian and Chinese to work within my custom cms. The characters do not show correctly eventhough they are correct in the database.

 

In the beginning, I couldn't even enter these into the database manualy without some specific characters getting messed up. This problem I tackled by changing the latin1_swedish_ci to utf8_bin and this seems to work fine.

 

Now my big problems are ;

 

1) somehow eventhough the text (characters) are in the database correctly and show correctly if I look through phpMyAdmin, they again show incorrectly when I call them up in my php file/website. (see attachments)

 

2) the same if I insert text through htmlArea editor, the text gets saved incorrectly.

 

Could someone tell me how to solve this problem?  Please let me know I'm completely lost on this one

 

Thanks,

 

Stepan

 

[attachment deleted by admin]

[ToonMariner]

this could be more that you don't have the character support on your machine...

 

 

[Daniel0]

Well, he could type it in and show it correctly in the first screenshot, so it isn't his computer. Check that you output it in utf8 in screenshot 2.

[stepanek]

this could be more that you don't have the character support on your machine...

 

 

 

hmmm... no, because in that case the text wouldn't show up correctly on other websites or documents....  

 

I think I might have it working now... for Czech language anyway, going to test Romanian and Chinese now.

 

(used the following ;

 

mysql_query("SET CHARACTER SET utf8");

mysql_query("SET NAMES utf8");

 

and in my html ;

 

<meta http-equiv="Content-Type" content="text/html;charset=utf-8" >

 

and database field(s) set to utf8-bin

 

hopefully this will work.