Caractertes raros en Shell de MySQL
Por más vueltas que le dé, sigo viendo caracteres raros en el shell de MySQL.
Acompaño dos importantes consultas:
mysql> show variables like 'char%';
+--------------------------+-----------------------------------+
| Variable_name | Value |
+--------------------------+-----------------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | C:\Servidor\MySQL\share\charsets\ |
+--------------------------+-----------------------------------+
8 rows in set (0.00 sec)
mysql> show variables like 'colla%';
+----------------------+------------------+
| Variable_name | Value |
+----------------------+------------------+
| collation_connection | utf8_general_ci |
| collation_database | utf8_general_ci |
| collation_server | utf8_general_ci |
+----------------------+------------------+
3 rows in set (0.00 sec)
Como verán, los charset y las collation soportan español. Ahora, fíjense lo que ocurre cuando ejecuto un
SELECT sobre la tabla "user".
n Este username es "n". Ok
+æe+æe Este username es "ÑeÑe". Mal
+æosvald+¦ Este username es "Ñosvaldó". Mal
o+¦jose Este username es "oñjose". Mal
phpMyAdmin+æ Este username es "phpMyAdminÑ". Mal
-Ñe-Ñe Este username es "¥e¥e". Mal (Bueno, este más bien es una locura. jajajaj)
Pregunta: NO ENTIENDO POR QUE en MySQL se ve mal cuando en el browser se ve bien inclusive sin poner la etiqueta meta de utf8
y en PhPMyAdmin se ve (sacando el último registro)perfecto ?????????????
Subject
Views
Written By
Posted
Caractertes raros en Shell de MySQL
3614
July 03, 2007 02:37PM
2952
July 05, 2007 10:05AM
2380
July 06, 2007 12:45PM
2735
July 17, 2007 05:16AM
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.