How to conserve the integrity of the string from a database response using Python

Hidura hidura at gmail.com
Thu Feb 17 23:19:55 EST 2011


Hello, i am using py-postgresql as the driver the database, when make a
select to a string with non-ASCII characters, the response replace the
character with "�" what can i make to change this to the correct character?

This is my code:

<code>class decodify:

    def __init__(self):
        db = pgDriver.connect(user = 'demo', password='demo'
database='hidura_karinapp', host='localhost', port='5432')
        d = db.prepare("""SELECT modules_reg.code FROM modules_reg,
domain_reg, sbdomain_reg, sbdomdl_asc where(modules_reg.id =
sbdomdl_asc.module AND modules_reg.mdname = 'police' AND sbdomain_reg.id =
sbdomdl_asc.domain AND sbdomain_reg.domain = domain_reg.id AND
domain_reg.dname = 'bmsuite.com' AND sbdomain_reg.sbname = 'www')""")
        s = d()
        print(s)

if __name__ == '__main__':
    decodify()</code>

-- 
Diego I. Hidalgo D.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/python-list/attachments/20110218/89738991/attachment.html>


More information about the Python-list mailing list