mysql:9485
From: <yasuyuki@xxxxxxxxxx>
Date: Mon, 31 May 2004 19:16:32 +0900
Subject: [mysql 09485] Re: UTF-8でのUpdate
えんどうです。 > "Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and > (utf8_general_ci,COERCIBLE) for operation '='" create table で、tx_name カラムの character set を明示的に指定していますか? create table tbl_test ( tx_name varchar(255) character set utf8, ... ); -- ENDO Yasuyuki <yasuyuki@xxxxxxxxxx> http://www.kahua.org/ http://www.timedia.co.jp/
9484 2004-05-31 18:41 [yyuji <yyuji@xxxxxxx] UTF-8でのUpdate -> 9485 2004-05-31 19:16 ┣[<yasuyuki@xxxxxxxxxx] 9486 2004-05-31 19:35 ┃┗[yyuji <yyuji@xxxxxxx] 9487 2004-05-31 20:01 ┃ ┗[<yasuyuki@xxxxxxxxxx] 9499 2004-06-01 10:38 ┃ ┗[yyuji <yyuji@xxxxxxx] 9503 2004-06-01 12:59 ┃ ┗["HIROSE, Masaaki" <h] 9504 2004-06-01 13:18 ┃ ┣[yyuji <yyuji@xxxxxxx] 9505 2004-06-01 13:35 ┃ ┗["TAKAHASHI, Tomohiro] 9500 2004-06-01 11:18 ┗[ML account <ml@xxxxx] 9506 2004-06-01 13:41 ┗[yyuji <yyuji@xxxxxxx] 9510 2004-06-01 16:51 ┣[<yasuyuki@xxxxxxxxxx] 9513 2004-06-01 19:56 ┃┗[yyuji <yyuji@xxxxxxx] 9516 2004-06-01 20:25 ┃ ┗[<yasuyuki@xxxxxxxxxx] 9524 2004-06-02 18:07 ┃ ┗[yyuji <yyuji@xxxxxxx] 9511 2004-06-01 17:16 ┗[ML account <ml@xxxxx] 9514 2004-06-01 19:58 ┣[yyuji <yyuji@xxxxxxx] 9515 2004-06-01 20:22 ┗[yyuji <yyuji@xxxxxxx]