summaryrefslogtreecommitdiff
path: root/examples/encoding.py
diff options
context:
space:
mode:
authorFederico Di Gregorio <fog@initd.org>2005-06-13 06:25:06 +0000
committerFederico Di Gregorio <fog@initd.org>2005-06-13 06:25:06 +0000
commit9c284f457042cad50beb5730ac7f8c4a36eacae2 (patch)
tree7edea4fb77fc0986e89d408ed37085e60a357691 /examples/encoding.py
parent0c56bc95df1cb34343e1866cf2a671c61076cb81 (diff)
downloadpsycopg2-9c284f457042cad50beb5730ac7f8c4a36eacae2.tar.gz
psycopg->psycopg2 switch in the examples.
Diffstat (limited to 'examples/encoding.py')
-rw-r--r--examples/encoding.py32
1 files changed, 16 insertions, 16 deletions
diff --git a/examples/encoding.py b/examples/encoding.py
index 1506252..d29a050 100644
--- a/examples/encoding.py
+++ b/examples/encoding.py
@@ -19,63 +19,63 @@ DSN = 'dbname=test'
## don't modify anything below this line (except for experimenting)
-import sys, psycopg
+import sys, psycopg2
import psycopg.extensions
if len(sys.argv) > 1:
DSN = sys.argv[1]
print "Opening connection using dns:", DSN
-conn = psycopg.connect(DSN)
+conn = psycopg2.connect(DSN)
print "Initial encoding for this connection is", conn.encoding
print "\n** This example is supposed to be run in a UNICODE terminal! **\n"
print "Available encodings:"
-for a, b in psycopg.extensions.encodings.items():
+for a, b in psycopg2.extensions.encodings.items():
print " ", a, "<->", b
print "Using STRING typecaster"
print "Setting backend encoding to LATIN1 and executing queries:"
conn.set_client_encoding('LATIN1')
curs = conn.cursor()
-curs.execute("SELECT %s::TEXT AS foo", ('àèìòù',))
+curs.execute("SELECT %s::TEXT AS foo", ('�����',))
x = curs.fetchone()[0]
print " ->", unicode(x, 'latin-1').encode('utf-8'), type(x)
-curs.execute("SELECT %s::TEXT AS foo", (u'àèìòù',))
+curs.execute("SELECT %s::TEXT AS foo", (u'�����',))
x = curs.fetchone()[0]
print " ->", unicode(x, 'latin-1').encode('utf-8'), type(x)
print "Setting backend encoding to UTF8 and executing queries:"
conn.set_client_encoding('UNICODE')
curs = conn.cursor()
-curs.execute("SELECT %s::TEXT AS foo", (u'àèìòù'.encode('utf-8'),))
+curs.execute("SELECT %s::TEXT AS foo", (u'�����'.encode('utf-8'),))
x = curs.fetchone()[0]
print " ->", x, type(x)
-curs.execute("SELECT %s::TEXT AS foo", (u'àèìòù',))
+curs.execute("SELECT %s::TEXT AS foo", (u'�����',))
x = curs.fetchone()[0]
print " ->", x, type(x)
print "Using UNICODE typecaster"
-psycopg.extensions.register_type(psycopg.extensions.UNICODE)
+psycopg2.extensions.register_type(psycopg2.extensions.UNICODE)
print "Setting backend encoding to LATIN1 and executing queries:"
conn.set_client_encoding('LATIN1')
curs = conn.cursor()
-curs.execute("SELECT %s::TEXT AS foo", ('àèìòù',))
+curs.execute("SELECT %s::TEXT AS foo", ('�����',))
x = curs.fetchone()[0]
print " ->", x.encode('utf-8'), ":", type(x)
-curs.execute("SELECT %s::TEXT AS foo", (u'àèìòù',))
+curs.execute("SELECT %s::TEXT AS foo", (u'�����',))
x = curs.fetchone()[0]
print " ->", x.encode('utf-8'), ":", type(x)
print "Setting backend encoding to UTF8 and executing queries:"
conn.set_client_encoding('UNICODE')
curs = conn.cursor()
-curs.execute("SELECT %s::TEXT AS foo", (u'àèìòù'.encode('utf-8'),))
+curs.execute("SELECT %s::TEXT AS foo", (u'�����'.encode('utf-8'),))
x = curs.fetchone()[0]
print " ->", x.encode('utf-8'), ":", type(x)
-curs.execute("SELECT %s::TEXT AS foo", (u'àèìòù',))
+curs.execute("SELECT %s::TEXT AS foo", (u'�����',))
x = curs.fetchone()[0]
print " ->", x.encode('utf-8'), ":", type(x)
@@ -84,19 +84,19 @@ print "Executing full UNICODE queries"
print "Setting backend encoding to LATIN1 and executing queries:"
conn.set_client_encoding('LATIN1')
curs = conn.cursor()
-curs.execute(u"SELECT %s::TEXT AS foo", ('àèìòù',))
+curs.execute(u"SELECT %s::TEXT AS foo", ('�����',))
x = curs.fetchone()[0]
print " ->", x.encode('utf-8'), ":", type(x)
-curs.execute(u"SELECT %s::TEXT AS foo", (u'àèìòù',))
+curs.execute(u"SELECT %s::TEXT AS foo", (u'�����',))
x = curs.fetchone()[0]
print " ->", x.encode('utf-8'), ":", type(x)
print "Setting backend encoding to UTF8 and executing queries:"
conn.set_client_encoding('UNICODE')
curs = conn.cursor()
-curs.execute(u"SELECT %s::TEXT AS foo", (u'àèìòù'.encode('utf-8'),))
+curs.execute(u"SELECT %s::TEXT AS foo", (u'�����'.encode('utf-8'),))
x = curs.fetchone()[0]
print " ->", x.encode('utf-8'), ":", type(x)
-curs.execute(u"SELECT %s::TEXT AS foo", (u'àèìòù',))
+curs.execute(u"SELECT %s::TEXT AS foo", (u'�����',))
x = curs.fetchone()[0]
print " ->", x.encode('utf-8'), ":", type(x)