никак не хочет поставить кодировку cp1251 по умолчанию.
В результате при люой операции получаю:
Could not process query 'SELECT tpl,UNIX_TIMESTAMP(added) FROM templates WHERE grp='index' AND name='INDEX'': Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation '=';
mysql_client_encoding($link); в php возвращает latin1_swedish_ci, а SHOW VARIABLES пишет что везде cp1251;
mysql собирался из портов:
make -DWITH_CHARSET=cp1251 -DWITH_XCHARSET=all
make deinstall
make install clean
мой my.cnf:
[client]
#password = your_password
port = 3306
socket = /tmp/mysql.sock
default-character-set=cp1251
character-sets-dir=/usr/local/share/mysql/charsets/
default-character-set=cp1251
# Here follows entries for some specific programs
# The MySQL server
[mysqld]
default-character-set=cp1251
port = 3306
socket = /tmp/mysql.sock
skip-locking
set-variable = key_buffer=16M
set-variable = max_allowed_packet=1M
set-variable = table_cache=64
set-variable = sort_buffer=512K
set-variable = net_buffer_length=8K
set-variable = myisam_sort_buffer_size=8M
#log-bin
server-id = 1
[mysqldump]
quick
set-variable = max_allowed_packet=16M
[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
default-character-set=cp1251
[isamchk]
set-variable = key_buffer=20M
set-variable = sort_buffer=20M
set-variable = read_buffer=2M
set-variable = write_buffer=2M
[myisamchk]
set-variable = key_buffer=20M
set-variable = sort_buffer=20M
set-variable = read_buffer=2M
set-variable = write_buffer=2M
[mysqlhotcopy]
interactive-timeout
p.s. все на FreeBSD 5.2.1
Вариант для распечатки
WEB технологии (Public)
(ok) on
17-Авг-04, 14:12 (MSK)
