[Python-sybase-misc] Selecting univarchar columns

[Jeffrey Z. <Jef...@q-...>]

When I execute a simple SELECT statement that includes columns of type
UNIVARCHAR, python-sybase throws a TypeError exception as shown here:

 

Traceback (most recent call last):

  File
"/home/jeffreyz/workspace-3.5/sybase-tests/src/connection_tests.py",
line 61, in <module>

    cursor.execute("SELECT AccountTypeID, Description FROM AccountType")

  File "build/bdist.linux-i686/egg/Sybase.py", line 554, in execute

  File "build/bdist.linux-i686/egg/Sybase.py", line 703, in _start

  File "build/bdist.linux-i686/egg/Sybase.py", line 736, in _mainloop

  File "build/bdist.linux-i686/egg/Sybase.py", line 775, in _row_result

  File "build/bdist.linux-i686/egg/Sybase.py", line 689, in _fetch_rows

  File "build/bdist.linux-i686/egg/Sybase.py", line 292, in _extract_row

TypeError: unknown data format

 

In this example, the column "Description" is of type UNIVARCHAR(50).  Is
this a known problem and is there a fix?

 

I compiled python-sybase on Ubuntu Linux with the ASE 15.02 Express
Edition for Linux. 

 

Has anyone else tried to select Unicode columns with any success?

 

Regards,

Jeffrey