Hi Ananda
that worked fine:
mysql> alter table suomi_contacts2 modify history longtext character set
utf8 collate utf8_bin;
Query OK, 6327 rows affected (0.34 sec)
Records: 6327 Duplicates: 0 Warnings: 0
mysql>
mysql> update suomi_contacts2 set history = concat(now(), ' ', ''
,'concerne: utf-8-bin collation for chinese charset',' ', 'Hoi
Suomixer,\r\n\r\nIf you\'re careful enough, nothing bad or good will
ever happen to you.\r\n> 葛斯克 愛德華 / 台北市八德路四段\r\n>\r\n\r\n\r
\nsuomi\r\n044 280 22 44\r\n079 239 29 01\r\n', ' ',
'----------------------- ', history) where counter = 1127;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql>
Thank you very 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