Right character encoding

Databases
1

Greets,

I am from the Ukraine. The language we speak here is either Russian or Ukrainian.

Anyways, I created a table, here is its dump:


--
-- Table structure for table `news`
--

DROP TABLE IF EXISTS `news`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `news` (
  `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(50) NOT NULL,
  `text` text NOT NULL,
  `posted` date NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `news`
--

LOCK TABLES `news` WRITE;
/*!40000 ALTER TABLE `news` DISABLE KEYS */;
INSERT INTO `news` VALUES (1,'Приближается сезон скидок','Как известно большинство строительных компиний зимой уходят на заслуженный отдых, но мы остаёмся работать для вас. По мимо всего прочего мы предоставляем скидку на нашу продукцию в размере 10%. Звоните!','2010-09-18');
/*!40000 ALTER TABLE `news` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

I have inserted some data, in Russian. Then I run SELECT * FROM news through mysql terminal and I see some nonsense, as if character encoding was set wrong.
Anyone has anything to say about it?
Thanks.

2

I apologize but can someone confirm to me that the mysql terminal that I reach on Windows through — Run > cmd > mysql -u root -p xxxxx — does not support letters other than English?

I outputted what I called “mess” in my previous post into a page and all characters looks just fine, so no problems with charset there?! What is going on? Are you following me? :slight_smile: