Real datatype is returning wrong values while using ibm_db or ibm_db_dbi

[GoogleCodeExporter]

What steps will reproduce the problem?
1. import ibm_db
ibm_db_conn = ibm_db.connect('test', 'db2inst1', 'secret')
import ibm_db_dbi
conn = ibm_db_dbi.Connection(ibm_db_conn)
cur = conn.cursor()
cur.execute("select distinct * from geography where ID = '1'")
cur.rowcount
print cur.fetchone()

stmt = ibm_db.exec_immediate(ibm_db_conn, "select distinct * from 
geography where ID = '1'")
a = ibm_db.fetch_tuple(stmt) 
print a

What is the expected output? What do you see instead?
Expected output is the value in table, instead we see some garbage values.

Please use labels and text to provide additional information.

Original issue reported on code.google.com by abhigyan...@in.ibm.com on 11 Nov 2008 at 9:51

[GoogleCodeExporter]

internal issue no. 168619

Original comment by abhigyan...@in.ibm.com on 11 Nov 2008 at 9:52

[GoogleCodeExporter]

I am providing a patch for version 0.4.1 fixing REAL datatype problem.

Original comment by abhigyan...@in.ibm.com on 11 Nov 2008 at 12:55

• Changed state: Fixed

Attachments:

• ibm_db_patch.txt