List:General Discussion« Previous MessageNext Message »
From:Ananda Kumar Date:August 31 2010 1:41pm
Subject:Re: collation problems
View as plain text  
did u try changing the collation for history column to UTF8
and try the update.



2010/8/31 mysql <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