[Previo por Fecha] [Siguiente por Fecha] [Previo por Hilo] [Siguiente por Hilo]
[Hilos de Discusión] [Fecha] [Tema] [Autor]garaged wrote:
NO es la tabla la que quiero cambiar, esas ya estan bien, , lo que necesito cambiar es la variable del sistema mysql que se llama *collation connection en phpmyadmin sale cuando le das que te muestre las varibles de mysql. Esa variable esta marcada como* utf8_general_ci y eso me esta dando problemas. donde le cambio eso? lo sabes?Me parece que estas malinterpretando el problema, a ver si esto te sirve: http://www.informit.com/articles/article.asp?p=328641&seqNum=3&rl=1
The reason this occurs is that usernames are stored using UTF8 (see Section 3.6, "UTF8 for Metadata <http://www.informit.com/articles/sam03_sam_0672326337_05.html>"). As a result, the USER() function and the literal string '@' have different character sets (and thus different collations):
mysql> *SELECT COLLATION(USER()), COLLATION('@');* +-------------------+-------------------+ | COLLATION(USER()) | COLLATION('@') | +-------------------+-------------------+ | utf8_general_ci | latin1_swedish_ci | +-------------------+-------------------+One way to deal with this is to tell MySQL to interpret the literal string as utf8:
mysql> *SELECT SUBSTRING_INDEX(USER(),_utf8'@',1);* +------------------------------------+ | SUBSTRING_INDEX(USER(),_utf8'@',1) | +------------------------------------+ | root | +------------------------------------+Another way is to change the connection character set and collation to utf8. You can do that with SET NAMES 'utf8' or by setting the character_set_connection and collation_connection system variables directly.
Ves???????????????????? es la connection character lo que esta mal.... te lo comente y no me crees.