Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email firstname.lastname@example.org
From: Ricardo Dias Marques (newsgroup.postsgmail.com)
Date: Wed Aug 08 2007 - 12:42:35 CDT
Here I am, following up to my own post - available below and at
http://lists.mysql.com/mysql/208343 - with a solution (basically, a
To summarize: I couldn't enter Portuguese accented characters in
"MySQL monitor" (MySQL command line / console client), when I'm in a
SSH (Secure Shell) Session, in a SUSE Linux Enterprise Server 10,
configured to use Unicode (UTF-8 encoding).
The Portuguese accented characters appeared well, in the same SSH
session, for other shell (bash) commands and in Vim editing sessions
(using the same Portuguese keyboard with accent keys that are "dead
To make a long story short, the problem does NOT seem to be related
with the SSH session, but seems to be related with the shell *user*
that I use to login:
1 - If I log in to the shell of the Linux server with a regular user,
either through a SSH session or directly in the local console (the one
physically attached to the server) and I do a "su" to change to the
"root" user, then the following happens: when I enter the mysql
console (by entering the "mysql" command), the accented characters do
NOT appear (typing ã - lowercase a with tilde accent - appears as a #
- hash sign).
2 - If I log in to the shell of the Linux server directly with the
"root" user, when I enter the mysql console (by entering the "mysql"
command) all the accented characters appear correctly (this also
happens either in a SSH session or by logging in directly in the local
Like I said in my previous post, this server has the following MySQL version:
"5.0.41-community MySQL Community Edition (GPL)".
I forgot to mention that I'm using bash shell - "GNU bash, version
3.1.17(1)-release (i586-suse-linux)" and that my readline version is
The bug is also happening in another server that's using version
"5.0.45-community MySQL Community Edition (GPL)".
Did anyone else have this problem? If so, how did you solve it? Did
you change everything from UTF-8 back to ISO-8859-1? *Or* do you enter
directly as "root", as I'm doing now (to work around this issue)? *Or*
do you simply do NOT type accented characters directly in the MySQL
Monitor (that is, the command line mysql client)?
Thanks in advance for any info that you may give me! :)
Ricardo Dias Marques
newsgroup DOT posts AT gmail DOT com
On 7/31/07, Ricardo Dias Marques <newsgroup.postsgmail.com> wrote:
> Hi all,
> First of all, sorry for the lengthy subject, but it serves to describe
> my problem:
> I'm having problems entering Portuguese accented characters (with a
> Portuguese keyboard) in "MySQL monitor" (MySQL command line / console
> client), when I'm in a SSH (Secure Shell) Session, in a Linux Server
> configured to use Unicode (UTF-8 encoding).
> I'm using "dead keys" - http://en.wikipedia.org/wiki/Dead_key - to
> enter the accented characters. That is, if I press the ã (tilde sign)
> key on my keyboard and then press "a" (lowercase a) then I get "ã"
> (lowercase a with tilde accent).
> This is a sample output from a SSH session, from a computer running
> "putty" version 0.60 (in Windows XP Professional with Service Pack 2)
> to my Linux Server (Suse Linux Enterprise Server 10 - aka SLES 10),
> located in the same LAN:
> # whoami
> # echo "Áá Ãã Çç"
> Áá Ãã Çç
> [ Great... Portuguese characters seem to be working well so far, both
> in the input and in output. Now, I'll enter the mysql console: ]
> # mysql
> Welcome to the MySQL monitor. Commands end with ; or \g.
> Your MySQL connection id is 3
> Server version: 5.0.41-community MySQL Community Edition (GPL)
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
> [ OK... Let me try to enter one lowercase ã - "a" with tilde accent ]
> mysql> #
> Now, you may be wondering why I'm getting that "hash" sign instead of
> "ã" (lower case a with tilde) ... I'm wondering the same thing! ;-)
> The funny thing is that if I try to type other accented characters, in
> this "mysql" console, it does NOT display ANY character!
> Here's the output of \s (status):
> mysql> \s
> mysql Ver 14.12 Distrib 5.0.41, for pc-linux-gnu (i686) using readline 5.0
> Connection id: 5
> Current database:
> Current user: rootlocalhost
> SSL: Not in use
> Current pager: less
> Using outfile: ''
> Using delimiter: ;
> Server version: 5.0.41-community MySQL Community Edition (GPL)
> Protocol version: 10
> Connection: Localhost via UNIX socket
> Server characterset: latin1
> Db characterset: latin1
> Client characterset: utf8
> Conn. characterset: utf8
> UNIX socket: /var/lib/mysql/mysql.sock
> Uptime: 1 hour 40 min 38 sec
> And here's the output of the character set variables:
> mysql> show variables like 'char%';
> | Variable_name | Value |
> | character_set_client | utf8 |
> | character_set_connection | utf8 |
> | character_set_database | latin1 |
> | character_set_filesystem | binary |
> | character_set_results | utf8 |
> | character_set_server | latin1 |
> | character_set_system | utf8 |
> | character_sets_dir | /usr/share/mysql/charsets/ |
> 8 rows in set (0.00 sec)
> I also tried to change all the character sets to utf8 by changing the
> /etc/my.cnf file (by setting default-character-set=utf8 in the
> [client] and [mysqld] sections of that file). That DID change all
> these character_set variables to utf8, but it did NOT solve my
> accented characters problem.
> If I log in the to local console (the one that is PHYSICALLY connected
> to the server) and I enter the mysql console, all the characters
> appear correctly. But, if in that same local console, I do a ssh
> 127.0.0.1 (to create a ssh connection to that same machine) I get
> AGAIN the same problem with the accented characters in the mysql
> console (commands entered outside the mysql console DO appear
> So, I'm guessing this is NOT a problem with putty (I also tried to use
> SecureCRT, also set to UTF8, with the same results), but that it is
> instead some kind of missing or wrong configuration of mysql (Server
> and/or Client) and/or some other variable that I must set in the SSH
> daemon (sshd) in /etc/ssh/sshd_config
> By the way, this is the output of my locale command in the SSH session:
> # locale
> My sshd_config file DOES have the following lines, at the end:
> AcceptEnv LANG LC_CTYPE LC_NUMERIC LC_TIME LC_COLLATE LC_MONETARY LC_MESSAGES
> AcceptEnv LC_PAPER LC_NAME LC_ADDRESS LC_TELEPHONE LC_MEASUREMENT
> AcceptEnv LC_IDENTIFICATION LC_ALL
> The SSH Daemon of the Linux Server is running OpenSSH. The OpenSSH
> version is "OpenSSH_4.2p1, OpenSSL 0.9.8a 11 Oct 2005"
> Any tips or information... please? :)
> Thanks in advance!
> Best wishes,
> Ricardo Dias Marques
> newsgroup DOT posts AT gmail DOT com
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql