mysql's russian character problem?

Question

I'm building a website and i'm using XAMPP (which includes Mysql in it). when i create a table inside the database in russian everythig goes ????????. So i tried changing collation. I looked at the Charset and tried everything that said Russian, then characters were showing correctly on phpmyadmin, but when i preview my website on a browser after i link the database all the characters go ??????? all over again and couple of english words that were in there show fine. I know i have all the fonts on my machine i just don't know what went wrong. Anybody would like to suggest anything?

Answer 1

check your ".htaccess" file.

there must be such string "AddDefaultCharset utf-8"

Instead of utf-8 you can use something else (win1251??) - depents on MySQL charset used.

Answer 2

For boys: Aleksandr, Pyotr, Mikhail, Nikolai, Vadim, Gavriil, Konstantin, Vasily, Fyodor. For girls: Nadya, Ekaterina, Olga, Irina, Katya, Lena, Mischa, Oksana, Svetlana, Vasilissa. Konstantin or Aleksandr are good names for a tyrannical father; Mikhail and Fyodor, in my mind, are better suited to a lover, with possible nicknames like Misha, Masha, or Fedya. Russians love their nicknames. One person may answer to a different name for everyone he knows, and lots of names have the same accepted nicknames. If you read a book like The Brothers Karamazov or Anna Karenina, it's confusing because every character is referred to by approximately 14 names.

Answer 3

just user server.htmlencode method to display the character clearly in web site it the corrector is correctly stored in mysql then server.htmlencode is best way to do .. i have already do it in making pashtoo and Urdu web site