More often at connection through unixODBC I receive this error, and only sometimes connected successfully. # cat /etc/unixODBC/odbc.ini [ODBC Data Sources] myodbc-5.1-quik = MySQL ODBC myodbc-5.1.6 Driver DSN [myodbc-5.1-quik] Description = MySQL ODBC myodbc-5.1.6 Driver DSN Driver = myodbc-5.1 Socket = /var/run/mysqld/mysqld.sock Server = localhost User = root Database = quik Option = 3 Charset = cp1251 # cat /etc/unixODBC/odbcinst.ini [myodbc-5.1] Description = MySQL ODBC myodbc-5.1.6 Driver Driver = /usr/lib/libmyodbc5.so --- If I delete a line 'Charset = cp1251' it is connected all times, but gives out an incorrect fields 'CHAR' and 'VARCHAR'. It is correct, because charset issue. So I create the table in mysql: > create database quik character set cp1251 collate cp1251_general_ci; > create table xxx (...) character set cp1251 collate cp1251_general_ci; Global mysql charset is UTF8. There is my /etc/mysql/my.cnf [client] port = 3306 socket = /var/run/mysqld/mysqld.sock [mysql] character-sets-dir=/usr/share/mysql/charsets default-character-set=utf8 [mysqladmin] character-sets-dir=/usr/share/mysql/charsets default-character-set=utf8 [mysqlcheck] character-sets-dir=/usr/share/mysql/charsets default-character-set=utf8 [mysqldump] character-sets-dir=/usr/share/mysql/charsets default-character-set=utf8 [mysqlimport] character-sets-dir=/usr/share/mysql/charsets default-character-set=utf8 [mysqlshow] character-sets-dir=/usr/share/mysql/charsets default-character-set=utf8 [myisamchk] character-sets-dir=/usr/share/mysql/charsets [myisampack] character-sets-dir=/usr/share/mysql/charsets [mysqld_safe] err-log = /var/log/mysql/mysql.err [mysqld] character-set-server = utf8 default-character-set = utf8 user = mysql port = 3306 socket = /var/run/mysqld/mysqld.sock pid-file = /var/run/mysqld/mysqld.pid log-error = /var/log/mysql/mysqld.err basedir = /usr datadir = /var/lib/mysql skip-locking key_buffer = 16M max_allowed_packet = 1M table_cache = 64 sort_buffer_size = 512K net_buffer_length = 8K read_buffer_size = 256K read_rnd_buffer_size = 512K myisam_sort_buffer_size = 8M language = /usr/share/mysql/english bind-address = 127.0.0.1 log-bin server-id = 1 tmpdir = /tmp/ innodb_buffer_pool_size = 16M innodb_additional_mem_pool_size = 2M innodb_data_file_path = ibdata1:10M:autoextend:max:128M innodb_log_file_size = 5M innodb_log_buffer_size = 8M set-variable = innodb_log_files_in_group=2 innodb_flush_log_at_trx_commit = 1 innodb_lock_wait_timeout = 50 innodb_file_per_table [mysqldump] quick max_allowed_packet = 16M [isamchk] key_buffer = 20M sort_buffer_size = 20M read_buffer = 2M write_buffer = 2M [myisamchk] key_buffer = 20M sort_buffer_size = 20M read_buffer = 2M write_buffer = 2M [mysqlhotcopy] interactive-timeout --- If I replace utf8 to cp1251 and restart mysqld it does not help. I have mysql-5.1.44-r1. THX. Reproducible: Sometimes Steps to Reproduce:
Please file an upstream bug with more details about the actual ODBC error output. Also, test out mysql-5.1.45-r1.
