List:General Discussion« Previous MessageNext Message »
From:mysql Date:August 31 2010 3:12pm
Subject:[SOLVED] Re: collation problems
View as plain text  
Hi Ananda
that worked fine:

mysql> alter table suomi_contacts2 modify history longtext character set 
utf8 collate utf8_bin;
Query OK, 6327 rows affected (0.34 sec)
Records: 6327  Duplicates: 0  Warnings: 0

mysql>

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\n044 280 22 44\r\n079 239 29 01\r\n', ' ', 
'----------------------- ', history) where counter = 1127;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql>

Thank you very much

suomi

On 2010-08-31 15:41, Ananda Kumar wrote:
> did u try changing the collation for history column to UTF8
> and try the update.
>
> 2010/8/31 mysql <mysql@stripped <mailto:mysql@stripped>>
>
>     On 2010-08-31 15:17, Ananda Kumar wrote:
>      > desc suomi_contacts2;
>
>     mysql> desc suomi_contacts2;
>    
> +------------------+------------------+------+-----+-------------------+-----------------------------+
>     | Field            | Type             | Null | Key | Default           |
>     Extra                       |
>    
> +------------------+------------------+------+-----+-------------------+-----------------------------+
>     | name             | text             | YES  |     | NULL              |
>                                 |
>     | firm             | text             | YES  |     | NULL              |
>                                 |
>     | title            | text             | YES  |     | NULL              |
>                                 |
>     | phone            | text             | YES  |     | NULL              |
>                                 |
>     | phone_std        | text             | YES  |     | NULL              |
>                                 |
>     | fax              | text             | YES  |     | NULL              |
>                                 |
>     | mail             | text             | YES  |     | NULL              |
>                                 |
>     | standard_mail    | text             | YES  |     | NULL              |
>                                 |
>     | comment          | text             | YES  |     | NULL              |
>                                 |
>     | status           | text             | YES  |     | NULL              |
>                                 |
>     | url              | text             | YES  |     | NULL              |
>                                 |
>     | businesscategory | text             | YES  |     | NULL              |
>                                 |
>     | address          | text             | YES  |     | NULL              |
>                                 |
>     | addon            | text             | YES  |     | NULL              |
>                                 |
>     | givenname        | text             | YES  |     | NULL              |
>                                 |
>     | history          | longtext         | YES  |     | NULL              |
>                                 |
>     | favorit          | text             | YES  |     | NULL              |
>                                 |
>     | last_update      | timestamp        | NO   |     | CURRENT_TIMESTAMP |
>     on update CURRENT_TIMESTAMP |
>     | task_link        | int(11)          | YES  |     | NULL              |
>                                 |
>     | counter          | int(10) unsigned | NO   | PRI | NULL              |
>     auto_increment              |
>    
> +------------------+------------------+------+-----+-------------------+-----------------------------+
>     20 rows in set (0.00 sec)
>
>     mysql>
>
>     --
>     MySQL General Mailing List
>     For list archives: http://lists.mysql.com/mysql
>     To unsubscribe: http://lists.mysql.com/mysql?unsub=1
>
>

Thread
collation problemsmysql31 Aug
  • Re: collation problemsAnanda Kumar31 Aug
    • Re: collation problemsmysql31 Aug
      • Re: collation problemsAnanda Kumar31 Aug
        • Re: collation problemsmysql31 Aug
          • Re: collation problemsAnanda Kumar31 Aug
            • Re: collation problemsmysql31 Aug
            • [SOLVED] Re: collation problemsmysql31 Aug