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