header("Content-Type: text/html; charset=utf-8");

AddDefaultCharset UTF-8

Microsoft Windows XP [Версия 5.1.2600]
(С) Корпорация Майкрософт, 1985-2001.

C:\Documents and Settings\Admin.MAX>mysql -u root -p
Enter password: ***********
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.1.24-rc-community MySQL Community Server (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use tsm_site;
Database changed
mysql> status;
--------------
mysql  Ver 14.14 Distrib 5.1.24-rc, for Win32 (ia32)

Connection id:          3
Current database:       tsm_site
Current user:           root@localhost
SSL:                    Not in use
Using delimiter:        ;
Server version:         5.1.24-rc-community MySQL Community Server (GPL)
Protocol version:       10
Connection:             localhost via TCP/IP
Server characterset:    utf8
Db     characterset:    utf8
Client characterset:    utf8
Conn.  characterset:    utf8
TCP port:               3306
Uptime:                 28 min 46 sec

Threads: 1  Questions: 19  Slow queries: 0  Opens: 17  Flush tables: 1  Open tab
les: 9  Queries per second avg: 0.11
--------------

mysql> show variables like 'char%';
+--------------------------+------------------------------+
| Variable_name            | Value                        |
+--------------------------+------------------------------+
| character_set_client     | utf8                         |
| character_set_connection | utf8                         |
| character_set_database   | utf8                         |
| character_set_filesystem | binary                       |
| character_set_results    | utf8                         |
| character_set_server     | utf8                         |
| character_set_system     | utf8                         |
| character_sets_dir       | D:\PHP\mysql\share\charsets\ |
+--------------------------+------------------------------+
8 rows in set (0.00 sec)

mysql> describe news;
+-------+-----------+------+-----+---------+----------------+
| Field | Type      | Null | Key | Default | Extra          |
+-------+-----------+------+-----+---------+----------------+
| id    | int(11)   | NO   | PRI | NULL    | auto_increment |
| name  | char(250) | NO   |     | NULL    |                |
| descr | char(250) | NO   |     | NULL    |                |
| cont  | text      | NO   |     | NULL    |                |
| dat   | date      | NO   |     | NULL    |                |
+-------+-----------+------+-----+---------+----------------+
5 rows in set (0.00 sec)

mysql> insert into news (name, descr, cont, dat) values ('Максим', 'Максим',
    -> 'Максим', '2000-02-01');
ERROR 1366 (HY000): Incorrect string value: '\x8C\xA0\xAA\xE1\xA8\xAC' for colum
n 'name' at row 1