Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
2.3.3, 3.0.3
-
None
-
None
-
Linux
Description
When I am trying to connect to a MySQL server with character_set_server set to utf16, it returns error:
*Variable 'character_set_client' can't be set to the value of 'utf16'. *
I am able to connect to the server using MySQL and MariaDB(10.2.10-MariaDB) command line tools.
Attachments
Activity
Added character_set_server=utf16 in my.cnf file and restarted server to set character_set_server.
From command line:
>mysql -hlocalhost -uusername -p -Pport
it is connecting.
When I use sample program(MariaDB C connector) to connect to the same server it is giving error "Variable 'character_set_client' can't be set to the value of 'utf16".
| Field | Original Value | New Value |
|---|---|---|
| Description |
When I am trying to connect to a MySQL server with character_set_server is set to utf16, it returns error:
*Variable 'character_set_client' can't be set to the value of 'utf16'. * I am able to connect to the server using MySQL and MariaDB(10.2.10-MariaDB) command line tools. |
When I am trying to connect to a MySQL server with character_set_server set to utf16, it returns error:
*Variable 'character_set_client' can't be set to the value of 'utf16'. * I am able to connect to the server using MySQL and MariaDB(10.2.10-MariaDB) command line tools. |
The mysql command line client specifies a default character set before connecting to server:
mysql -uroot -e"SELECT @@character_set_client,@@character_set_server";
|
+------------------------+------------------------+
|
| @@character_set_client | @@character_set_server |
|
+------------------------+------------------------+
|
| utf8 | utf16 |
|
+------------------------+------------------------+
|
|
|
mysql -uroot --default-character-set=utf16;
|
ERROR 1231 (42000): Variable 'character_set_client' can't be set to the value of 'utf16'
|
If no client character set was specified, the client will use the server character set. This is of course not possible for several character sets like utf16 or ucs2 and will abort the connection.
| issue.field.resolutiondate | 2018-03-07 07:52:41.0 | 2018-03-07 07:52:41.718 |
| Fix Version/s | N/A [ 19504 ] | |
| Resolution | Not a Bug [ 6 ] | |
| Status | Open [ 1 ] | Closed [ 6 ] |
I am able to connect to that server using MariaDB client(10.2.10-MariaDB) also. MariaDB 10.2 all client tools use C/C 3.0.x. Is MariaDB client also set default character set before connecting to the server?
Command line client use settings from configuration file or if not specified sets the default client character set to utf8 (and in older versions to latin1).
Tried adding default-character-set=utf8 to my.cnf but the issue still persists. Can you please tell me the parameters required to add in my.cnf file so that it will connect to that server programmatically.
Tried with MySQL #[Connector/C 6.1.11 and I am able to connect to the MySQL server. The issue is reproducible only with MariaDB C connector.
Hi Sandhya,
thanks for the update. Looks like you forgot to attach the source of your test case.
| Attachment | mysql.cpp [ 45347 ] |
| Attachment | mysql.cpp [ 45347 ] |
| Attachment | mysql.cpp [ 45348 ] |
Sample program attached. To reproduce this issue set character_set_server set to utf16 in my.cnf.
Any update on this issue?
Please reopen this issue as it is not solved yet.
| Resolution | Not a Bug [ 6 ] | |
| Status | Closed [ 6 ] | Stalled [ 10000 ] |
| Fix Version/s | N/A [ 19504 ] |
| Fix Version/s | 3.0.4 [ 22922 ] | |
| Fix Version/s | 2.3.6 [ 23004 ] |
| issue.field.resolutiondate | 2018-04-18 05:42:01.0 | 2018-04-18 05:42:01.851 |
| Resolution | Fixed [ 1 ] | |
| Status | Stalled [ 10000 ] | Closed [ 6 ] |
| Workflow | MariaDB connectors [ 85885 ] | MariaDB v4 [ 161103 ] |
Sorry, but I don't understand your issue:
Can you please explain how you connect with command line client with client_character_set utf16 ?