can u please list out the table structure...as collation can also be set at column level
regards anandkl On Tue, Aug 31, 2010 at 6:00 PM, mysql <my...@ayni.com> wrote: > Hi listers > mysql server here is > > mysql-server-5.1.48-2.fc13.x86_64 > > this morning i created a message with a literal string in chinese in it. > the messages in the application i used are stored in a mysql database, when > you submit them, like in a "sent" folder. > With this chinese literal in it, i, however, got > ERROR 1271 (HY000): Illegal mix of collations for operation 'concat' > > when i sent the message. > > without the chinese literal, the message was stored in the mysql db > correctly. > > i, then, changed the connection names to utf8 and collation to utf8_bin and > then the session parameters looked like: > > mysql> set names "utf8"; > Query OK, 0 rows affected (0.00 sec) > > mysql> set collation_connection = "utf8_bin"; > Query OK, 0 rows affected (0.00 sec) > > mysql> show session variables like "character_set%"; > +--------------------------+----------------------------+ > | 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.00 sec) > > mysql> show session variables like "collation%"; > +----------------------+-------------------+ > | Variable_name | Value | > +----------------------+-------------------+ > | collation_connection | utf8_bin | > | collation_database | latin1_swedish_ci | > | collation_server | latin1_swedish_ci | > +----------------------+-------------------+ > 3 rows in set (0.00 sec) > > mysql> > > i thought, if you set the collation_connection to utf8_bin, you may send > fairly everything to mysql. > > > but still, when i tried to concat the new string (including the chinese > characers) i got: > > mysql> update suomi_contacts2 set history = concat(now(), ' ', '' > ,'concerne: utf-8-bin collation for chinese charset',' ', 'Hoi > Suomixer,\r\n\r\nIf you\'re careful enough, nothing bad or good will ever > happen to you.\r\n> 葛斯克 愛德華 / 台北市八德路四段\r\n>\r\n\r\n \r\nsuomi\r\n', ' ', > '----------------------- ', history) where counter = 1127; > ERROR 1271 (HY000): Illegal mix of collations for operation 'concat' > > > > Question: What did i miss? what do i have to change? > > Thanks in advance > > suomi > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=anan...@gmail.com > >
