MySQL Forums
Forum List  »  Newbie

Can't insert special characters (for example í,ñ or °) in mysql command line
Posted by: Nicolas Celedón Canales
Date: July 30, 2015 08:53AM

The Problem:
On the keyboard, when I press the "ñ" key, or intend to insert "í","ó","ü" or "°", these doesn't apper on the command line. Also, if i try to copy some of those characters, i have the same problem. For example I copy "María", but when i try to paste in the comand line, it appears "Mara".

Aditional Information:
I tried these under the following version

mysql Ver 14.14 Distrib 5.6.25, for debian-linux-gnu (i686) using EditLine wrapper

When I connet to the database i use the following sintax:

mysql -u root -h localhost -p

Also, when i execute this:

SHOW VARIABLES LIKE 'char%'; SHOW VARIABLES LIKE 'collation%';

I got the following output:

+--------------------------+----------------------------+
| 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,05 sec)

+----------------------+-------------------+
| Variable_name | Value |
+----------------------+-------------------+
| collation_connection | utf8_general_ci |
| collation_database | latin1_swedish_ci |
| collation_server | latin1_swedish_ci |
+----------------------+-------------------+
3 rows in set (0,00 sec)


Hope someone could help me. Thanks!

Options: ReplyQuote


Subject
Written By
Posted
Can't insert special characters (for example í,ñ or °) in mysql command line
July 30, 2015 08:53AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.