Printing character data results from Teradata results in "\x00\x00\x00\x00" prefixed tuple/mangled data...

[GoogleCodeExporter]

What steps will reproduce the problem?
1. Connect to Teradata (version 12 or 13) from Linux using pyodbc 2.1.8 + 
python 2.4.
2. Do a SHOW TABLE on an object
3. Print the rows from the fetchall()

What is the expected output?

Something like:

("CREATE SET TABLE dba_tool.test1 ,NO FALLBACK ,
     NO BEFORE JOURNAL,
     NO AFTER JOURNAL,
     CHECKSUM = DEFAULT
     (
      t1 INTEGER,
      HOST_IP_ADDR CHAR(16)

[truncated output...]

What do you see instead?

("\x00\x00\x00\x00TE SET TABLE dba_tool.test1 ,NO FALLBACK ,
     NO BEFORE JOURNAL,
     NO AFTER JOURNAL,
     CHECKSUM = DEFAULT
     (
      t1 INTEGER,
      HOST_IP_ADDR CHAR(16)

[truncated output...]

What version of the product are you using? On what operating system?

Using Pyodbc 2.1.8.  Running on RHES, as below

uname -a 
Linux phxaisadm002 2.6.18-194.el5 #1 SMP Tue Mar 16 21:52:39 EDT 2010 x86_64 
x86_64 x86_64 GNU/Linux

Please provide any additional information below.

Original issue reported on code.google.com by textur...@gmail.com on 18 Dec 2010 at 8:40