Re: [PyDB2-discuss] Problem retrieving LONGVARBINARY column

[Jon T. <jon...@gm...>]

Hi,
Sorry about taking my time to respond, I've not had much free time.
I have a few questions:

1) what is DDL statement used to create this table? I'm guessing something like
CREATE TABLE Table1  (Column1 LONG VARCHAR FOR BIT DATA) ;

Is that correct?

2) What codepage and region do you have set for your db? What is the
locale on the db computer?

3) Are you setting the value of the column from python? If so, can you
show me a code snippet, that shows how you're setting the value?

Thanks a lot,
Jón

2008/2/27 SERXIO BARRAL PAN/ Generali-España <s.b...@ge...>:
>
> Hi!
>
> I'm struggling to retrieve a LONGVARBINARY column with pydb2 module. By
> using several fetchone(), or one fetchall() I get several 32000 bytes chunks
> that are the ascii hex representation of the binary data in the database.
> The problem is that I should be getting chunks of 32000 bytes being them the
> real binary data, not its ascii hex double-byte representation. And of
> course, If I translate these ascii data to the binary data, I do have just
> 16000 bytes, missing 16000 more.
>
> I'm using pydb2 1.1.1
>