[前][次][番号順一覧][スレッド一覧]

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]