------------------- On Saturday 27 November 2004 12:52, Gleb Paharenko wrote: | Hello. | | Strange behavior. You said that both servers configured to use latin1? | What output produced

Can only do with for the local server, access is denied to the mysql shell on the shared hosting. But it's the local system that's causing the unexpected effects:

| show variables like '%char%';

character_set latin1 character_sets latin1 big5 [...bunch of others including latin5 - no utf-8 to be seen anywhere...] convert_character_set

| show variables like '%colla%';

empty set

| show create database 'database_name';

ERROR 1064: [sql syntax error]

| show create table 'table_name';

ERROR 1064: [sql syntax error]

| on both servers? Also send your my.cnf files.

[client] port = 3306 socket = /var/lib/mysql/mysql.sock default-character-set = latin1

[mysqld] port = 3306 socket = /var/lib/mysql/mysql.sock datadir = /share/mysql/data 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

[safe_mysqld] err-log=/var/lib/mysql/mysqld.log

[mysqldump] quick set-variable = max_allowed_packet=16M

[mysql] no-auto-rehash

[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