1 юпр
2 лсгшйю
5 йхмн
3 ондхсл
4 едю
6 цняреопххлярбн
8 мнбнярх
9 ютхью
10 юбрн
11 ймхцх

#!/usr/bin/env python
#-*-coding:utf-8-*-

import MySQLdb
import string

db_host = 'xxx' 
db_user = 'xxx'
db_pass = 'xxx'
db_name = 'xxx'
db_char = 'ascii'

db = MySQLdb.connect(host=db_host, user=db_user, passwd=db_pass, db=db_name)
cursor = db.cursor()

#cursor.execute('SET NAMES koi8r');	
#cursor.execute('SET character_set_client="ascii"');	
#cursor.execute('SET character_set_results="ascii"');	
#cursor.execute('SET collation_connection="ascii"');

cursor.execute("SELECT `section_id`, `section_name` FROM `gloss`")

numrows = int(cursor.rowcount)

data =  cursor.fetchall()

for rec in data:
    
    section_id, section_name = rec
    
    print section_id, section_name


db.close()

[client]
default-character-set = utf8

[mysqld]
character-set-server=utf8
collation-server=utf8_unicode_ci
init_connect='set collation_connection = utf8_unicode_ci;'