Am Dienstag, den 09.08.2005, 17:57 +0400 schrieb Alexey Polyakov:
> If charsets/collations are not set explicitly in my.cnf, server could
> be using ones specified during compilation.
> To check charsets and collations on the running server do:
> show global variables like 'c%';
Thanks.
I executed the statement on both servers and got identical results! So
no diffenrence exists between the server configuration, right ? How can
it be that I get the collation error ?
Following the statement results:
On the Master:
--------------
HAL2005:~ # mysql -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1803 to server version: 4.1.12-standard-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> show global variables like 'c%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
| collation_connection | latin1_swedish_ci |
| collation_database | latin1_swedish_ci |
| collation_server | latin1_swedish_ci |
| concurrent_insert | ON |
| connect_timeout | 5 |
+--------------------------+----------------------------+
12 rows in set (0.00 sec)
On the Slave:
-------------
HAL2006:/var/lib/mysql # mysql -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 7 to server version: 4.1.12-standard-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> show global variables like 'c%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
| collation_connection | latin1_swedish_ci |
| collation_database | latin1_swedish_ci |
| collation_server | latin1_swedish_ci |
| concurrent_insert | ON |
| connect_timeout | 5 |
+--------------------------+----------------------------+
12 rows in set (0.07 sec)
Any ideas ?!
Marco
---
http://www.tuxoo.de
http://www.kontaktlinsen-preisvergleich.de
