Details
-
Task
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
Description
According to the documentation, trying to set the variable character_set_results should done by something like:
[mysqld]
|
datadir=C:/Program Files/MariaDB 10.5/data
|
port=3306
|
default-storage-engine=MyISAM
|
skip-innodb
|
#innodb_buffer_pool_size=1010M
|
character-set-results=utf8mb4
|
[client]
|
port=3306
|
plugin-dir=C:/Program Files/MariaDB 10.5/lib/plugin
|
But trying to start the server fails:
C:\Program Files\MariaDB 10.5\bin>mariadbd --console
|
2021-07-07 17:24:40 0 [Note] mariadbd (mysqld 10.5.9-MariaDB) starting as process 1664 ...
|
2021-07-07 17:24:40 0 [Note] Plugin 'InnoDB' is disabled.
|
2021-07-07 17:24:40 0 [Note] Plugin 'FEEDBACK' is disabled.
|
2021-07-07 17:24:40 0 [Note] CONNECT: Version 1.07.0002 Feb 19 2021 10:36:16
|
2021-07-07 17:24:40 0 [ERROR] mariadbd: unknown variable 'character-set-results=utf8mb4'
|
2021-07-07 17:24:40 0 [ERROR] Aborting
|
This happens with all character set variables. Other variables can be set without problems.
Attachments
Issue Links
- relates to
-
MDEV-26105 MariaDB 10.6 cannot be used from C# client applications
-
- Closed
-
-
-
- Closed
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Description |
According to the documentation, trying to set the variable character_set_results should done by something like:
{code} [mysqld] datadir=C:/Program Files/MariaDB 10.5/data port=3306 innodb_buffer_pool_size=1010M character-set-results=utf8mb4 [client] port=3306 plugin-dir=C:/Program Files/MariaDB 10.5/lib/plugin {code} But trying to start the server fails: {noformat} C:\Program Files\MariaDB 10.5\bin>mariadbd --console 2021-07-07 17:24:40 0 [Note] mariadbd (mysqld 10.5.9-MariaDB) starting as process 1664 ... 2021-07-07 17:24:40 0 [Note] Plugin 'InnoDB' is disabled. 2021-07-07 17:24:40 0 [Note] Plugin 'FEEDBACK' is disabled. 2021-07-07 17:24:40 0 [Note] CONNECT: Version 1.07.0002 Feb 19 2021 10:36:16 2021-07-07 17:24:40 0 [ERROR] mariadbd: unknown variable 'character-set-results=utf8mb4' 2021-07-07 17:24:40 0 [ERROR] Aborting {noformat} This happens with all character set variables. Other variables can be set without problems. |
According to the documentation, trying to set the variable character_set_results should done by something like:
{code} [mysqld] datadir=C:/Program Files/MariaDB 10.5/data port=3306 default-storage-engine=MyISAM skip-innodb #innodb_buffer_pool_size=1010M character-set-results=utf8mb4 [client] port=3306 plugin-dir=C:/Program Files/MariaDB 10.5/lib/plugin {code} But trying to start the server fails: {noformat} C:\Program Files\MariaDB 10.5\bin>mariadbd --console 2021-07-07 17:24:40 0 [Note] mariadbd (mysqld 10.5.9-MariaDB) starting as process 1664 ... 2021-07-07 17:24:40 0 [Note] Plugin 'InnoDB' is disabled. 2021-07-07 17:24:40 0 [Note] Plugin 'FEEDBACK' is disabled. 2021-07-07 17:24:40 0 [Note] CONNECT: Version 1.07.0002 Feb 19 2021 10:36:16 2021-07-07 17:24:40 0 [ERROR] mariadbd: unknown variable 'character-set-results=utf8mb4' 2021-07-07 17:24:40 0 [ERROR] Aborting {noformat} This happens with all character set variables. Other variables can be set without problems. |
| Fix Version/s | N/A [ 14700 ] | |
| Resolution | Not a Bug [ 6 ] | |
| Status | Open [ 1 ] | Closed [ 6 ] |
| Comment |
[ Well, I understand. However, it is needed for C# client applications (see |
Well, I understand. However, it is needed for C# client applications (see MDEV-26105) so the fix is to make it a command-line or config-file option.
| Resolution | Not a Bug [ 6 ] | |
| Status | Closed [ 6 ] | Stalled [ 10000 ] |
| Affects Version/s | 10.2.39 [ 25731 ] | |
| Affects Version/s | 10.3.30 [ 25732 ] | |
| Affects Version/s | 10.4.20 [ 25733 ] | |
| Affects Version/s | 10.5.11 [ 25734 ] | |
| Affects Version/s | 10.6.3 [ 25904 ] | |
| Environment | Windows 10 | |
| Issue Type | Bug [ 1 ] | Task [ 3 ] |
for mysql command line client it's the option --default-character=set that sets character_set_result.
For mysql-conector-net supposedly one can specify charset as a connection option, like "server=127.0.0.1;uid=root;pwd=12345;charset=utf8mb4".
| Labels | need_feedback |
Of course it is a client option. Trying to set --default-character-set when starting the server fails.
Specifying character set
Use this one to specify which character set to use to encode queries sent to the server.
Server=myServerAddress;Database=myDB;Uid=myUsername;Pwd=myPwd;CharSet=utf8;
|
Note that resultsets still are returned in the character set of the data returned.
| Link |
This issue relates to |
| Link |
This issue relates to |
| Workflow | MariaDB v3 [ 123323 ] | MariaDB v4 [ 131748 ] |
| Status | Stalled [ 10000 ] | Open [ 1 ] |
| Status | Open [ 1 ] | Needs Feedback [ 10501 ] |
| Labels | need_feedback |
| Assignee | Sergei Golubchik [ serg ] | |
| Status | Needs Feedback [ 10501 ] | Open [ 1 ] |
This is because character-set-results does not exist as a command-line or a config-file option, it is only a global/session variable. In the documentation, the absence of a command-line/config-file capability can be recognized by not having a line "Commandline" in the description, e.g. here ( https://mariadb.com/kb/en/server-system-variables/#character_set_results ), while the next one - character_set_server - has "Commandline: --character-set-server"