Home

Advertisement

ちなみにMySQLのCharsetの確認

  • Dec. 7th, 2007 at 6:44 AM
http://www.flickr.com/photos/20958118@N0
import clr
clr.AddReferenceByPartialName ('System.Data')
clr.AddReferenceToFile ('MySql.Data.dll')

from System.Data import *
from MySql.Data.MySqlClient import *

connstr = 'server=%s;User Id=%s;Password=%s;Database=%s' % ('192.168.250.217','wordpress', 'wordpress', 'wordpressme')

def show_charset(conn):
    cmd = conn.CreateCommand ()
    cmd.CommandText = 'show variables like  \'char%\''
    r = cmd.ExecuteReader ()
WS000007    while r.Read ():
        print '%s:%s' % (r[0], r[1])
    r.Close ()

conn = None
try:
    conn = MySqlConnection (connstr)
    conn.Open ()
    show_charset(conn)
finally:
    if not conn is None:
        conn.Close ()
 




Hatena タグ: ,,