Michael Bayer [2011-07-16 04:56] :

> what's the space in there for ? that's why the comparison fails, not the unicode issue. interpreting CHAR differently ?
>
>

Seems that there is a problem with the driver itself

conn = firebirdsql.connect(dsn=TEST_DSN, user=TEST_USER,
password=TEST_PASS, port=3050, charset='ISO8859_1' )
cur = conn.cursor()
cur.execute("select 'a' from rdb$database")
for c in cur.fetchall():
print(c)
cur = conn.cursor()
cur.execute("select _UTF8 'a' from rdb$database")
for c in cur.fetchall():
print(c)

return :
[u'a']
[u'a']


where using the default charset (UTF8) it return :
[u'a ']
[u'a ']




--
Philippe Makowski
http://www.ibphoenix.com
Supporting users of Firebird
Tel +33 (0) 561058813