Subject different encoding for varchar and blob
Author Peter Irbizon
Hello guys,
 
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