Subject Re: [firebird-python] Re: sqlalchemy ticket 2125
Author Hajime Nakagami
Sorry It has problem, so  fix it
https://github.com/nakagami/pyfirebirdsql/commit/f5a23411b78d086d984e9ac095de6c2a6b74bf4e

2011/7/18 Hajime Nakagami <nakagami@...-net.ne.jp>
Hi everyone,

I know the problem

In python2.x return string value as is in master HEAD now

Best Regards

2011/7/18 Philippe Makowski <makowski@...>
 

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