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