в 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 ? как подправить ?
mysql кодировка alt linux
Модераторы: Skull, Модераторы разделов