mysql кодировка alt linux

Модераторы: Skull, Модераторы разделов

ZloiJoker
Сообщения: 60

mysql кодировка alt linux

Сообщение ZloiJoker »

в my.cnf (под alt linux) /var/lib/mysql
[client]
default-character-set=cp1251

[mysqld]
character-sets-dir=/usr/share/mysql/charsets
character_set_server=cp1251
collation_server=cp1251_general_ci
..
..
..


mysql> status
--------------
mysql Ver 14.12 Distrib 5.0.18, for alt-linux-gnu (i586) using readline 5.1

Connection id: 23
Connection: Localhost via UNIX socket
Server characterset: koi8r
Db characterset: koi8r
Client characterset: cp1251
Conn. characterset: cp1251


mysql> SHOW VARIABLES LIKE 'character%'
-> ;
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | cp1251 |
| character_set_connection | cp1251 |
| character_set_database | koi8r |
| character_set_results | cp1251 |
| character_set_server | koi8r |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+


Как заменить везде koi8r на cp1251

откудого koi8r ? как подправить ?
Спасибо сказали: