Jython Data Extraction problem
Steve Williams
stevewilliams at wwc.com
Wed Mar 7 23:26:42 EST 2007
The data is an 8-byte 2s complement binary integer stored in a MSSQL
2005 CHAR column. (COBOL did that, not me). I'm using zxJDBC to read
the data and Jython to process.
I could extract the integer if it wasn't returned in the resultset as
unicode. Things like ord(char) and struct.unpack('>B',char) to get at
the bits don't seem to work. struct.unpack('>g',string) is not available.
I've tried fooling with charset in the url and the connect statement and
tried encode, but I have no experience here.
Is there anyway to get Jython/zxJDBC to stop converting the string to
unicode?
Any advice is welcome.
More information about the Python-list
mailing list