Can't insert special characters (for example í,ñ or °) in mysql command line
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!
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.