MySQL Forums
Forum List  »  Spanish

Caractertes raros en Shell de MySQL
Posted by: Claudio Martinez
Date: July 03, 2007 02:37PM

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 ?????????????

Options: ReplyQuote


Subject
Views
Written By
Posted
Caractertes raros en Shell de MySQL
3614
July 03, 2007 02:37PM


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.