Python¤Î2.5°Ê¹ß¤Ë¤Ï´û¤ËSQLite3¤¬´Þ¤Þ¤ì¤Æ¤¤¤ë¤Î¤Ç¡¢¸ÄÊ̤˥¤¥ó¥¹¥³¤ä¤éÀßÄê¤ÏɬÍפʤ¤¤Ç¤¹¡£
Jython¤â2.5¤Ê¥Ð¡¼¥¸¥ç¥ó¤¬¥ê¥ê¡¼¥¹¤µ¤ì¤ÆDerby¤¬É¸½à¤Ç»È¤¨¤ë¡£¤È¤«¤Ê¤é¤Ê¤¤¤«¤Ê¡¼¡¢¤È»×¤¤¤Ä¤Ä¡¢¤³¤³¤Ç¤ÏPython¤ÎÂÐÏå⡼¥É¥¢¥ì¥³¥ì¤·¤Æ¤ß¤Þ¤·¤¿¡£
¥³¥Í¥¯¥·¥ç¥ó¤Î¥ª¥Ö¥¸¥§¥¯¥È¤Ë°Ê²¼¤Î»ØÄê¤ò¤¹¤ì¤ÐÆüËܸìÌäÂê¤â²ò·è¤·¤Þ¤¹¡£
conn.text_factory=str
¤½¤ì¤«¥½¡¼¥¹¤ä¤éÆþ½ÐÎϤÎʸ»úÎóÁ´¤Æ¤òutf-8¤ÇÅý°ì¤¹¤ì¤ÐÌäÂê¤Ê¤¤¤ß¤¿¤¤¤Ç¤¹¡£
WindowsXP¤È¤«¤Ç¥½¥ì¤Ï¥¥Ä¤¤¤Î¤Ç¡¢¼«Ê¬¤Î¾ì¹ç¤Ï¤³¤ÎÊýË¡¤Ë¤ÆÂбþ¤·¤Þ¤¹¡£
Jython¤â2.5¤Ê¥Ð¡¼¥¸¥ç¥ó¤¬¥ê¥ê¡¼¥¹¤µ¤ì¤ÆDerby¤¬É¸½à¤Ç»È¤¨¤ë¡£¤È¤«¤Ê¤é¤Ê¤¤¤«¤Ê¡¼¡¢¤È»×¤¤¤Ä¤Ä¡¢¤³¤³¤Ç¤ÏPython¤ÎÂÐÏå⡼¥É¥¢¥ì¥³¥ì¤·¤Æ¤ß¤Þ¤·¤¿¡£
C:\>python Python 2.5.2 (r252:60911, Feb 21 2008, 13:11:45) [MSC v.1310 32 bit (Intel)] on win32 Type "help", "copyright", "credits" or "license" for more information. >>> import sqlite3 >>> conn = sqlite3.connect(":memory:") >>> conn.text_factory=str >>> c = conn.cursor() >>> c.execute("create table nerine (id int,name varchar(128))") <sqlite3.Cursor object at 0x00BF36B0> >>> c.execute("insert into nerine values(1,'¤Í¤ê¤Í')") <sqlite3.Cursor object at 0x00BF36B0> >>> c.execute("insert into nerine values(2,'¤×¤ê¤à¤é')") <sqlite3.Cursor object at 0x00BF36B0> >>> c.execute("insert into nerine values(3,'¤ê¤·¤¢¤ó¤µ¤¹')") <sqlite3.Cursor object at 0x00BF36B0> >>> c.execute("select * from nerine") <sqlite3.Cursor object at 0x00BF36B0> >>> for row in c: ... print "%s|%s" % tuple(row) ... 1|¤Í¤ê¤Í 2|¤×¤ê¤à¤é 3|¤ê¤·¤¢¤ó¤µ¤¹ >>> ^Z¤Ê¤Ë¤â¹Í¤¨¤º¤ËÆüËܸì¤ò»È¤¦¤Èinsert¤Ï¤È¤â¤«¤¯select¤ò¼Â¹Ô¤·¤¿»þ¤ËÎã³°¤¬¤Ç¤Æ¥¤¥ä¥ó¤Êµ¤Ê¬¤Ë¤Ê¤ê¤Þ¤¹¡£
¥³¥Í¥¯¥·¥ç¥ó¤Î¥ª¥Ö¥¸¥§¥¯¥È¤Ë°Ê²¼¤Î»ØÄê¤ò¤¹¤ì¤ÐÆüËܸìÌäÂê¤â²ò·è¤·¤Þ¤¹¡£
conn.text_factory=str
¤½¤ì¤«¥½¡¼¥¹¤ä¤éÆþ½ÐÎϤÎʸ»úÎóÁ´¤Æ¤òutf-8¤ÇÅý°ì¤¹¤ì¤ÐÌäÂê¤Ê¤¤¤ß¤¿¤¤¤Ç¤¹¡£
WindowsXP¤È¤«¤Ç¥½¥ì¤Ï¥¥Ä¤¤¤Î¤Ç¡¢¼«Ê¬¤Î¾ì¹ç¤Ï¤³¤ÎÊýË¡¤Ë¤ÆÂбþ¤·¤Þ¤¹¡£
¤³¤Î¥Ú¡¼¥¸¤Ø¤Î¥³¥á¥ó¥È
idLg4f Im grateful for the article.Really thank you! Great.