Can't get LCHARVAR's with InformixDB

[fhurley at gmail.com]

Carsten Haese wrote:
> Could you possibly send me a minimal test script that shows the problem?
> Also, in case it matters, I'd like to know which versions of IDS and
> CSDK or Informix Connect you're using.


Here's a sample script:

sql = '''select msg_tx from dev_log'''
import informixdb
conn = informixdb.connect('mydb')
cursor = conn.cursor()
cursor.execute(sql)
print 'description is <%s>' % cursor.description
print cursor.fetchall()

Output is:
description is <('msg_tx', 'lvarchar', 0, 0, None, None, 1)>
[('',), ('',), ('',), ('',), ('',), ('',)]

But one of them should be:
'''Something:SomethingElse - going for 221 possibilities [User:
HOST-NAME\XYZZY]:
Id	OtherData
5878	C
5968	X
6732	V
[many more lines like this]
'''

Some hunting around, and I found this:

C:\Program Files\Informix\Client-SDK\bin>esql
IBM Informix CSDK Version 2.80, IBM Informix-ESQL Version 9.52.TC1

Not sure what IDS is... the Informix Server version is: 9.3 FC3,
according to the DBA guy.

Thanks much.