Bug #24753 mysql shell --default-charset parameter works but \c does not.
Submitted: 1 Dec 2006 13:21 Modified: 1 Jan 2007 13:29
Reporter: FIRAT KUCUK Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: Command-line Clients Severity:S3 (Non-critical)
Version:5.0 OS:Linux (linux)
Assigned to: CPU Architecture:Any
Tags: mysql shell

[1 Dec 2006 13:21] FIRAT KUCUK
Description:
mysql> \C latin5
Charset changed
mysql> \s
--------------
mysql  Ver 14.12 Distrib 5.0.24a, for pc-linux-gnu (i486) using readline 5.1

Connection id:          6
Current database:
Current user:           root@localhost
SSL:                    Not in use
Current pager:          stdout
Using outfile:          ''
Using delimiter:        ;
Server version:         5.0.24a-Debian_9-log
Protocol version:       10
Connection:             Localhost via UNIX socket
Server characterset:    latin1
Db     characterset:    latin1
Client characterset:    latin1
Conn.  characterset:    latin1
UNIX socket:            /var/run/mysqld/mysqld.sock
Uptime:                 1 hour 30 min 4 sec

character set does not change.

pismikrop@kirmizi:/var/lib/locales/supported.d$ mysql -u root -p --default-character-set=latin5
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8 to server version: 5.0.24a-Debian_9-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> \s
--------------
mysql  Ver 14.12 Distrib 5.0.24a, for pc-linux-gnu (i486) using readline 5.1

Connection id:          8
Current database:
Current user:           root@localhost
SSL:                    Not in use
Current pager:          stdout
Using outfile:          ''
Using delimiter:        ;
Server version:         5.0.24a-Debian_9-log
Protocol version:       10
Connection:             Localhost via UNIX socket
Server characterset:    latin1
Db     characterset:    latin1
Client characterset:    latin5
Conn.  characterset:    latin5
UNIX socket:            /var/run/mysqld/mysqld.sock
Uptime:                 1 hour 31 min 34 sec

Threads: 1  Questions: 166  Slow queries: 0  Opens: 124  Flush tables: 1  Open tables: 40  Queries per second avg: 0.030
--------------

How to repeat:
always
[1 Dec 2006 13:29] Valeriy Kravchuk
Thank you for a problem report. Please, try to repeat with a newer version, 5.0.27, and inform about the results.
[2 Jan 2007 0:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".