did u try changing the collation for history column to UTF8 and try the update.
2010/8/31 mysql <my...@ayni.com> > 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=anan...@gmail.com > >