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

mysql:10308

From: "Makoto Goto" <"Makoto Goto" <gmakoto2001@xxxxxxxxxx>>
Date: Fri, 8 Oct 2004 13:39:26 +0900
Subject: [mysql 10308] Re: (³ô)¡¢(Í­)¤Ê¤É¤Îʸ»ú²½¤±²óÈòÊýË¡¤Ë¤Ä¤¤¤Æ

¤³¤ó¤Ë¤Á¤Ï¡£¸åÆ£¤Ç¤¹¡£

> ¤â¤·¥½¡¼¥¹¥³¡¼¥É¤òÊѹ¹¤µ¤ì¤ë¾ì¹ç¤Ï¡¢
> com.mysql.jdbc.CharsetMapping.java¤Î
> tempMap.put("sjis", "SJIS");
> ¤È¤¤¤¦¹Ô¤ò¡¢
> tempMap.put("sjis","MS932");
> ¤Ë½ñ¤­´¹¤¨¤Æ¥Ó¥ë¥É¤·Ä¾¤»¤ÐÎɤ¤¤³¤È¤ò¼Âµ¡¤Ç³Îǧ¤·¤Æ¤¤¤Þ¤¹¡£

Áᮥ½¡¼¥¹¥³¡¼¥É¤òÆþ¼ê¤·¡¢¥Ó¥ë¥É¤·Ä¾¤·¤Þ¤·¤¿¡£
Ä´ºº¤Î·ë²Ì²¼µ­¤Î¤³¤È¤¬¤ï¤«¤ê¤Þ¤·¤¿¡£

¥Ó¥ë¥É¤·Ä¾¤·ÈǤΥɥ饤¥Ð¤Ç¹Ô¤¦¾ì¹ç

­¡DBÅÐÏ¿
String url = "jdbc:mysql:///test?useUnicode=true&characterEncoding=MS932";
¤Ë¤¹¤ë¤È­ê­ë¤Îʸ»ú²½¤±¤Ï²óÈò¤Ç¤­¤ë¡£

­¢DB¼èÆÀ¢ªjspɽ¼¨
<%@ page contentType="text/html; charset=MS932" %>
¤òµ­½Ò¤·¤Æ¤ª¤±¤Ð

String url = "jdbc:mysql:///test?useUnicode=true&characterEncoding=sjis";
¤Ç¤â
String url = "jdbc:mysql:///test?useUnicode=true&characterEncoding=MS932";
¤Ç¤âʸ»ú²½¤±¤»¤ºÉ½¼¨²Äǽ¡£

¾åµ­¤Î¤è¤¦¤Ë­¡¤È­¢¤Î¾ò·ï¤òËþ¤¿¤»¤Ð
²óÈò¤Ç¤­¤ë¤³¤È¤¬¤Ç¤­¤Þ¤·¤¿¡£

¤¿¤À¤·¡¢¥ª¥é¥¯¥ë¤Ê¤ÉDB¤Î°Ü¿¢À­¤È¤«¤â¹Íθ¤¹¤ë¤È
PGÃæ¤Ïsjis¤ÇÅý°ì¤·¤Æ½èÍý¤·¤¿¤¤¤È»×¤¦¤Î¤Ç¤¹¤¬¡¢
¤½¤Î¾ì¹ç¤Ï¤ä¤Ï¤êmysql¤Ï4.0¤Ë¤¹¤ë¤Î¤¬
¥Ù¥¿¡¼¤Ê¤Î¤Ç¤·¤ç¤¦¤«?



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

     10296 2004-10-06 15:33 ["Matsunobu, Yoshinor] Re: (³ô)¡¢(Í­)¤Ê¤É¤Îʸ»ú²½¤±²óÈòÊýË¡¤Ë¤Ä¤¤¤Æ
     10300 2004-10-06 21:03 ¨²["Makoto Goto" <gmako]                                       
->   10308 2004-10-08 13:39 ¨±["Makoto Goto" <gmako]