0

I have table with USER VARCHAR(100) CHARACTER SET WIN1250, NOTE BLOB SUB_TYPE 1 CHARACTER SET WIN1250,

But when I pick up data from this table with kinterbasdb in python 2.7 (# -- coding: utf-8 --) VARCHAR field is ok but BLOB field seems to be "corrupted" and I must decode it with decode('cp1250'). Why this happens? Why it is necessary to decode BLOB field only and not VARCHAR?

Thanks for help

peter
  • 4,289
  • 12
  • 44
  • 67
  • As you have declared the BLOB as sub-type 1 i.e. text, i guess it is a bug in the db interface. – Leovt Apr 18 '12 at 21:18

1 Answers1

0

I need to call KInterbasDB.init(type_conv=300): http://www.firebirdsql.org/file/documentation/drivers_documentation/python/3.3.0/beyond-python-db-api.html#parameter-conversion

UpAndAdam
  • 4,515
  • 3
  • 28
  • 46
peter
  • 4,289
  • 12
  • 44
  • 67