[Á°][¼¡][ÈÖ¹æ½ç°ìÍ÷][¥¹¥ì¥Ã¥É°ìÍ÷]

mysql:11552

From: "T.Sasaki" <"T.Sasaki" <papasan2000@xxxxxxxxxx>>
Date: 10 Jun 2005 12:44:42 +0900
Subject: [mysql 11552] Re: MyODBC3.51¤ÈMySQL4.1.1¤Ç

¤È¤ê¤¢¤¨¤º 4.1.1-alpha ¤ÎÆ°ºî¤ò»î¤·¤Æ¤ß¤Þ¤·¤¿¡£

1.MySQL 4.1.1-alpha
  ./configure --with-charset=utf8 --with-extra-charsets=complex

2.server ujis, client sjis ¤Ë¤¹¤ë¤È¤­
  (1) ½é´üºî¶È
      my.cnf ¤Ø¼¡¤Î»ØÄê¤ò¹Ô¤¤¤Þ¤¹¡£
        [mysqld]
        default-character-set=ujis
      °Ê¸å¤ÏÄ̾ï¤Î½é´üºî¶È (mysql_install_db, mysqld start, GRANT) ¤ò¹Ô¤¤¤Þ¤¹¡£
      mysql ¥³¥Þ¥ó¥É¤Ç¥Æ¥¹¥ÈÍѥǡ¼¥¿¥Ù¡¼¥¹¤È¥Æ¡¼¥Ö¥ë¤òºîÀ®¤·¤Þ¤¹¡£

  (2) ODBC
      MyODBC-3.51.11-2 ¤ò¥¤¥ó¥¹¥È¡¼¥ë¤·¤Þ¤¹¡£
      ¥Ç¡¼¥¿¥½¡¼¥¹ÀßÄê¤ò¹Ô¤¤¤Þ¤¹¡£¤³¤Î¤È¤­¡¢Initial Statement ¤Ë
      SET CHARACTER SET SJIS ¤òµ­½Ò¤·¤Æ¤ª¤­¤Þ¤¹¡£

3.server utf8, client utf8 ¤Ë¤¹¤ë¤È¤­
  (1) ½é´üºî¶È
      my.cnf ¤Ø¼¡¤Î»ØÄê¤ò¹Ô¤¤¤Þ¤¹¡£
        [mysqld]
        default-character-set=utf8
      ¸å¤ÏƱ¤¸¤Ç¤¹¡£

  (2) ODBC
      Initial Statement ¤Ë SET CHARACTER SET UTF8 ¤òµ­½Ò¤·¤Æ¤ª¤­¤Þ¤¹¡£
      ¸å¤ÏƱ¤¸¤Ç¤¹¡£

4.Access2000 ¤ÇÆ°ºî³Îǧ
  ¥ê¥ó¥¯¥Æ¡¼¥Ö¥ë¤òºîÀ®¤·¤Æ¡¢¼ÂºÝ¤Ë¥ì¥³¡¼¥É¤òÆþÎϤ·¤Æ¤ß¤Þ¤¹¡£
  UTF8 ¤ò»ØÄꤷ¤¿¤È¤­¤Ï Windows µ¡¼ï°Í¸ʸ»ú¤¬°·¤¨¤Þ¤¹¡£
  Office2000 ¤«¤éÆâÉô¤Ç°·¤¦Ê¸»ú¥³¡¼¥É¤¬ unicode ¤Ë¤Ê¤ê¤Þ¤·¤¿¤¬¡¢
  ¶²¤é¤¯ MySQL server ¦¤ÎÅÔ¹ç¤ÇÂè3¿å½à´Á»ú°Ê¾å¤Ï»È¤¨¤Ê¤¤¤è¤¦¤Ç¤¹¡£
  »ÄÇ°¤Ç¤¹¤¬¡¢°·¤¨¤ëʸ»úÈÏ°Ï¤Ï Access2000 ¤ÈƱÅù¤Ç¤Ï¤¢¤ê¤Þ¤»¤ó¡£

¤³¤Á¤é¤Ç¤ÏÌäÂê¤Ê¤¯Æ°ºî¤·¤Þ¤¹¤Î¤Ç¡¢¤É¤³¤«¤ÇÀßÄê¤ò´Ö°ã¤¨¤Æ¤¤¤Þ¤¹¡£
phpMyAdmin ¤ÇÌäÂê¤Ê¤¯°·¤¨¤Æ¤¤¤ë¤Ê¤é¡¢´Ö°ã¤¤¤Ê¤¯¥¯¥é¥¤¥¢¥ó¥È¦¤ÎÌäÂê¤Ç¤¹¡£
¤Þ¤À²ò·è¤µ¤ì¤Æ¤¤¤Ê¤¤¤Ê¤é¡¢¾åµ­¤Î¤è¤¦¤Ê¼ê½ç¤Ç ODBC ºÆ¥¤¥ó¥¹¥È¡¼¥ë¤·¤Æ¤ß¤Æ¤¯¤À¤µ¤¤¡£

[Á°][¼¡][ÈÖ¹æ½ç°ìÍ÷][¥¹¥ì¥Ã¥É°ìÍ÷]

     11517 2005-06-02 15:00 [¹ÓÌÚ¡¡Ëþ <araki@xxxx] MyODBC3.51¤ÈMySQL4.1.1¤Ç                
     11518 2005-06-02 15:40 ¨²[´Ü»³ À»»Ê <tateyan@x]                                       
     11525 2005-06-03 21:47 ¨­¨±[¹ÓÌÚ¡¡Ëþ <araki@xxxx]                                     
     11527 2005-06-06 13:23 ¨­¡¡¨²[Hiroshi Moriyama <mt]                                   
     11536 2005-06-06 11:42 ¨­¡¡¨±[SUGIMURA Takashi ¿ùÂ]                                   
     11545 2005-06-08 22:28 ¨­¡¡¡¡¨±[¹ÓÌÚ¡¡Ëþ <araki@xxxx]                                 
     11547 2005-06-09 10:55 ¨­¡¡¡¡¡¡¨²[Hiroshi Moriyama <mt]                               
     11548 2005-06-09 12:09 ¨­¡¡¡¡¡¡¨±["T.Sasaki" <papasan2]                               
     11549 2005-06-09 20:31 ¨­¡¡¡¡¡¡¡¡¨±["T.Sasaki" <papasan2]                             
     11550 2005-06-09 20:49 ¨­¡¡¡¡¡¡¡¡¡¡¨±["T.Sasaki" <papasan2]                           
     11519 2005-06-02 16:01 ¨²[Hiroshi Moriyama <mt]                                       
     11520 2005-06-02 16:30 ¨­¨±[¹ÓÌÚ¡¡Ëþ <araki@xxxx]                                     
     11521 2005-06-02 19:06 ¨­¡¡¨±[Hiroshi Moriyama <mt]                                   
     11523 2005-06-03 21:15 ¨­¡¡¡¡¨±[¹ÓÌÚ¡¡Ëþ <araki@xxxx]                                 
     11526 2005-06-03 09:04 ¨²["Shuichi Tamagawa" <]                                       
->   11552 2005-06-10 12:44 ¨±["T.Sasaki" <papasan2]