Configuration file:

[client] port = %mysqlport% character-sets-dir = "%dprogdir%\\modules\\database\\%mysql_driver%\\share\\charsets" [mysql] character-sets-dir = "%dprogdir%\\modules\\database\\%mysql_driver%\\share\\charsets" no-auto-rehash no-beep [mysqld] #skip-character-set-client-handshake #skip-name-resolve #sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" %log%general_log = 1 %log%general_log_file = "%dprogdir%\\userdata\\logs\\%mysql_driver%_queries.log" back_log = 100 basedir = "%dprogdir%\\modules\\database\\%mysql_driver%" bind-address = %ip% bulk_insert_buffer_size = 2M character-set-server=%sqlchr% character-sets-dir = "%dprogdir%\\modules\\database\\%mysql_driver%\\share\\charsets" collation-server=%mysqlcharset% connect_timeout = 5 datadir = "%dprogdir%\\userdata\\%mysql_driver%" default-storage-engine=InnoDB expire_logs_days = 2 ft_min_word_len=4 init-connect="SET NAMES %sqlchr%" interactive_timeout=30 join_buffer_size = 1M key_buffer_size = 25M local-infile=1 secure-file-priv = "%dprogdir%\\userdata\\temp" log-error = "%dprogdir%\\userdata\\logs\\%mysql_driver%_error.log" lower_case_table_names = 2 max_allowed_packet = 32M max_connect_errors = 10 max_connections = 30 max_heap_table_size = 25M max_tmp_tables = 25 myisam-recover-options=backup,force myisam_max_sort_file_size = 256M myisam_repair_threads = 1 pid_file = "%dprogdir%\\userdata\\temp\\mysql.pid" port = %mysqlport% query_cache_limit = 256K query_cache_size=25M read_buffer_size=2M read_rnd_buffer_size=4M server-id = 1 skip-external-locking skip-innodb_adaptive_hash_index sort_buffer_size = 1M table_open_cache = 969 thread_cache_size = 4 tmp_table_size = 25M tmpdir = "%dprogdir%\\userdata\\temp" transaction-isolation = READ-COMMITTED wait_timeout=60 #innodb_fast_shutdown #innodb_file_per_table = 1 #innodb_force_recovery=1 #skip-innodb_doublewrite innodb_buffer_pool_instances=1 innodb_buffer_pool_size = 128M innodb_data_file_path = ibdata1:10M:autoextend innodb_data_home_dir = "%dprogdir%\\userdata\\%mysql_driver%" innodb_flush_log_at_trx_commit = 2 innodb_lock_wait_timeout = 30 innodb_log_buffer_size = 1M innodb_log_file_size = 64M innodb_log_files_in_group = 2 innodb_max_dirty_pages_pct = 90 innodb_read_io_threads=4 innodb_thread_concurrency=4 innodb_write_io_threads=4 [mysqldump] quick max_allowed_packet = 16M [myisamchk] key_buffer_size = 50M sort_buffer_size = 50M read_buffer = 8M write_buffer = 8M [mysqlhotcopy] interactive-timeout [mysqld_safe] open-files-limit = 2048

In the OpenServera settings, Mysql encoding is selected utf8_general_ci Which lines in the configuration need to be changed in order to always have Utf8

    1 answer 1

    Probably write something like:

     [client] default-character-set = utf8 ... [mysqld] init_connect='SET collation_connection = utf8_unicode_ci' character-set-server = utf8 collation-server = utf8_unicode_ci
    • I have already changed the encoding of the file used, was cp1532 - Fedor