Hi Ananda not sofar. But if you recommend it, i will give it a try.
thanks so 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 <my...@ayni.com <mailto: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
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
