Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Not a Bug
-
5.3.12
-
None
-
None
-
None
-
Ms Windows XP (sp3)
Description
I use MariaDB 5.3.12 at work (Windows XP sp3) and the my.ini file contains:
[mysql]
|
default-character-set=utf8
|
character-set-server=utf8
|
|
|
[client]
|
port=3306
|
default-character-set=utf8
|
character-set-server=utf8
|
|
|
[client-server]
|
#default-character-set=utf8
|
character-set-server=utf8
|
|
|
[client-mariadb]
|
default-character-set=utf8
|
character-set-server=utf8
|
|
|
[mysqld]
|
datadir=C:/webserver/MariaDB/data
|
port=3306
|
|
|
sql_mode="STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION"
|
default_storage_engine=innodb
|
character-set-server=utf8
|
|
|
innodb_additional_mem_pool_size=12M
|
innodb_buffer_pool_size=128M
|
innodb_data_file_path=ibdata1:10M:autoextend:max:300M
|
innodb_flush_log_at_trx_commit=2
|
innodb_file_format=barracuda
|
innodb_strict_mode=1
|
innodb_file_per_table=1
|
innodb_log_file_size=64M
|
|
|
key_buffer_size=32M
|
max_allowed_packet = 16M
|
max_connections=30
|
|
|
query_cache_size=16M
|
|
|
read_buffer_size=1M
|
read_rnd_buffer_size=2M
|
|
|
skip-federated
|
skip-archive
|
|
|
sort_buffer_size=1536K
|
thread_cache_size=20
|
tmp_table_size=64M
|
max_heap_table_size=64M
|
table_open_cache=2048
|
open_files_limit=4096
|
slow_query_log=1
|
slow_query_log_file=slow.log
|
log_queries_not_using_indexes=1
|
log_slow_time=2.0
|
general_log=0
|
lower_case_table_names=2
|
When invoking the mysql client utility, the character settings is ignored and I get:
MariaDB [(none)]> \s
|
--------------
|
mysql Ver 15.1 Distrib 5.3.12-MariaDB, for Win32 (ia32)
|
|
|
Connection id: 7
|
Current database:
|
Current user: root@localhost
|
SSL: Not in use
|
Using delimiter: ;
|
Server: MariaDB
|
Server version: 5.3.12-MariaDB-log mariadb.org binary distribution
|
Protocol version: 10
|
Connection: localhost via TCP/IP
|
Server characterset: utf8
|
Db characterset: utf8
|
Client characterset: latin1
|
Conn. characterset: latin1
|
TCP port: 3306
|
Uptime: 14 hours 32 min 1 sec
|
Of course, if I invoke the mysql utility with the --default-character-set=utf8 option, it works fine, but it's a bit annoying to always type it.