#!/usr/bin/python2.5
# -*- coding: utf-8 -*-

import sys, codecs
sys.stdout = codecs.EncodedFile(sys.stdout, "utf-8")

import sqlite3
conn = sqlite3.connect('test.db')
conn.row_factory = sqlite3.Row # this enables accessing results by name
c = conn.cursor()

query = "SELECT * FROM test;"
c.execute(query)

for row in c:
        print row["col1"]