Kako da promenim a da se zadrzi posle restarta mysql-a characterset latin2?
promenim ga ja sa:
set character_set_server=latin2
set character_set_client=latin2
set character_set_database=latin2
set character_set_result=latin2
set character_set_connetion=latin2
ali posle restarta servera (samo mysql-a) se sve vrati kako je bilo.... grrrr....
Dopuna: 09 Okt 2006 11:06
Rešeno!
/etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
old_passwords=1
character-set-server = latin2
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
[client]
default-character-set = latin2
i dobijam onda lepo:
mysql> show variables like '%charac%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | latin2 |
| character_set_connection | latin2 |
| character_set_database | latin2 |
| character_set_filesystem | binary |
| character_set_results | latin2 |
| character_set_server | latin2 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.01 sec)
|