List:General Discussion« Previous MessageNext Message »
From:mysql Date:August 31 2010 2:51pm
Subject:Re: collation problems
View as plain text  
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
>
>

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