[Ayuda] ODBC para CVS

[Iván Caballero Cano]

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.



 
_______________________________________________
Ayuda mailing list
Ayuda en linux.org.mx
Para salir de la lista: http://mail.linux.org.mx/cgi-bin/mailman/listinfo/ayuda/